SpreadSheet + Excel + Oracle + Xml (Synthesis Test)
2022. 7. 26.
TABLE CREATE TABLE TEST_SUBWAY( SUBWAY_NUMBER NUMBER NOT NULL PRIMARY KEY, SUBWAY_NAME VARCHAR2(81), SUBWAY_LINE VARCHAR2(81) ); INSERT INTO TEST_SUBWAY VALUES( 1119, '홍대입구역', '경의중앙선' ); UPDATE TEST_SUBWAY SET SUBWAY_NUMBER = 11111, SUBWAY_NAME = '서울역', SUBWAY_LINE = '1호선' WHERE SUBWAY_NUMBER = 1111 DELETE TEST_SUBWAY WHERE SUBWAY_NUMBER = 1119 SELECT * FROM TEST_SUBWAY ORDER BY SUBWAY_NUMBER AS..
