SELECT * FROM SEAT;
CREATE SEQUENCE SEQ_A1 START WITH 1 INCREMENT BY 1 NOCACHE;

INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_S1.NEXTVAL, 1, 'A1');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_S1.NEXTVAL, 1, 'A2');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_S1.NEXTVAL, 1, 'A3');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_S1.NEXTVAL, 1, 'A4');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_S1.NEXTVAL, 1, 'A5');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_S1.NEXTVAL, 1, 'A6');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_S1.NEXTVAL, 1, 'A7');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_S1.NEXTVAL, 1, 'A8');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_S1.NEXTVAL, 1, 'A9');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_S1.NEXTVAL, 1, 'A10');
COMMIT;

INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_A1.NEXTVAL, 2, 'A1');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_A1.NEXTVAL, 2, 'A2');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_A1.NEXTVAL, 2, 'A3');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_A1.NEXTVAL, 2, 'A4');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_A1.NEXTVAL, 2, 'A5');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_A1.NEXTVAL, 2, 'A6');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_A1.NEXTVAL, 2, 'A7');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_A1.NEXTVAL, 2, 'A8');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_A1.NEXTVAL, 2, 'A9');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_A1.NEXTVAL, 2, 'A10');
COMMIT;

INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_A1.NEXTVAL, 3, 'A1');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_A1.NEXTVAL, 3, 'A2');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_A1.NEXTVAL, 3, 'A3');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_A1.NEXTVAL, 3, 'A4');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_A1.NEXTVAL, 3, 'A5');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_A1.NEXTVAL, 3, 'A6');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_A1.NEXTVAL, 3, 'A7');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_A1.NEXTVAL, 3, 'A8');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_A1.NEXTVAL, 3, 'A9');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_A1.NEXTVAL, 3, 'A10');
COMMIT;

INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_A1.NEXTVAL, 4, 'A1');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_A1.NEXTVAL, 4, 'A2');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_A1.NEXTVAL, 4, 'A3');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_A1.NEXTVAL, 4, 'A4');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_A1.NEXTVAL, 4, 'A5');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_A1.NEXTVAL, 4, 'A6');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_A1.NEXTVAL, 4, 'A7');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_A1.NEXTVAL, 4, 'A8');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_A1.NEXTVAL, 4, 'A9');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_A1.NEXTVAL, 4, 'A10');
COMMIT;

INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_A1.NEXTVAL, 5, 'A1');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_A1.NEXTVAL, 5, 'A2');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_A1.NEXTVAL, 5, 'A3');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_A1.NEXTVAL, 5, 'A4');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_A1.NEXTVAL, 5, 'A5');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_A1.NEXTVAL, 5, 'A6');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_A1.NEXTVAL, 5, 'A7');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_A1.NEXTVAL, 5, 'A8');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_A1.NEXTVAL, 5, 'A9');
INSERT INTO SEAT(SCODE, THCODE, SNAME) VALUES (SEQ_A1.NEXTVAL, 5, 'A10');
COMMIT;

SELECT * FROM SEAT WHERE ORDER BY SCODE ASC;

이런식으로 테이블에 정보를 넣어두고 SCODE에 대해 오름차순으로 정렬을 하려 하는데 

사진과 같이 오류가 나네요,