디비버 오류 문의
디비버에서 첨부된 실습 기본 자료를 적용시키면
SQL Error [922] [42000]: ORA-00922: 누락된 또는 부적합한 옵션
라는 에러가 나오고 해당 자료들이 생성되지 않습니다
상세 내용은 아래와 같습니다.
------------------------------------------------------------------------------------------------
org.jkiss.dbeaver.model.sql.DBSQLException: SQL Error [922] [42000]: ORA-00922: 누락된 또는 부적합한 옵션
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:136)
at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeStatement(SQLQueryJob.java:704)
at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.lambda$executeSingleElement$1(SQLQueryJob.java:597)
at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:190)
at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeSingleElement(SQLQueryJob.java:616)
at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeSingleQuery(SQLQueryJob.java:478)
at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.extractData(SQLQueryJob.java:1089)
at org.jkiss.dbeaver.ui.editors.sql.QueryResultsContainer.readData(QueryResultsContainer.java:275)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.lambda$run$0(ResultSetJobDataRead.java:129)
at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:190)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.run(ResultSetJobDataRead.java:127)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetViewer$ResultSetDataPumpJob.run(ResultSetViewer.java:5358)
at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:110)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)
Caused by: java.sql.SQLSyntaxErrorException: ORA-00922: 누락된 또는 부적합한 옵션
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:702)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:608)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1335)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:1041)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:443)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:533)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:176)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1305)
at oracle.jdbc.driver.OracleStatement.executeSQLStatement(OracleStatement.java:1877)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1520)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2557)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:2506)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:334)
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.execute(JDBCStatementImpl.java:332)
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:134)
... 13 more
Caused by: Error : 922, Position : 120, SQL = create table country
(
country_name varchar(100),
capital_city varchar(100),
continent varchar(100)
);
INSERT INTO country (country_name, capital_city, continent) VALUES ('USA', 'Washington', 'America');
INSERT INTO country (country_name, capital_city, continent) VALUES ('England', 'London', 'Europe');
INSERT INTO country (country_name, capital_city, continent) VALUES ('S.Korea', ' Seoul', 'Asia');
INSERT INTO country (country_name, capital_city, continent) VALUES ('Australia', ' Canberra', 'Oceania');
INSERT INTO country (country_name, capital_city, continent) VALUES ('Ghana', 'Accra', 'Africa');
INSERT INTO country (country_name, capital_city, continent) VALUES ('Argentina', 'Buenos aires', 'America');
create table budget
(
do varchar(100) null,
city varchar(100) null,
budget_value int null,
population int null
);
INSERT INTO budget (do, city, budget_value, population) VALUES ('서울특별시', '서울특별시', 23324, 345);
INSERT INTO budget (do, city, budget_value, population) VALUES ('부산광역시', '부산광역시', 34323, 5345);
INSERT INTO budget (do, city, budget_value, population) VALUES ('경상남도', '창원시', 4331, 435);
INSERT INTO budget (do, city, budget_value, population) VALUES ('경상남도', '양산시', 25436, 2134);
INSERT INTO budget (do, city, budget_value, population) VALUES ('경상남도', '밀양시', 62341, 6523);
INSERT INTO budget (do, city, budget_value, population) VALUES ('경기도', '부천시', 3242, 345);
INSERT INTO budget (do, city, budget_value, population) VALUES ('경기도', '시흥시', 32454, 546);
INSERT INTO budget (do, city, budget_value, population) VALUES ('경기도', '수원시', 3234, 345);
INSERT INTO budget (do, city, budget_value, population) VALUES ('충청남도', '공주시', 2425, 436);
INSERT INTO budget (do, city, budget_value, population) VALUES ('충청남도', '논산시', 5534, 4567);
INSERT INTO budget (do, city, budget_value, population) VALUES ('강원도', '속초시', 6542, 3542);
INSERT INTO budget (do, city, budget_value, population) VALUES ('강원도', '강릉시', 23423, 4355);
INSERT INTO budget (do, city, budget_value, population) VALUES ('강원도', '태백시', 5465, 45);
INSERT INTO budget (do, city, budget_value, population) VALUES ('전라북도', '전주시', 456, 645);
INSERT INTO budget (do, city, budget_value, population) VALUES ('전라북도', '군산시', 3243, 234);
create table salary
(
id varchar2(10),
name varchar2(100),
bonus_type varchar2(3),
salary number,
bonus number
);
INSERT INTO SALARY (ID, NAME, BONUS_TYPE, SALARY, BONUS) VALUES ('A01', '대한', 'AB', 1000, 100);
INSERT INTO SALARY (ID, NAME, BONUS_TYPE, SALARY, BONUS) VALUES ('A02', '민국', 'AC', 1300, 90);
INSERT INTO SALARY (ID, NAME, BONUS_TYPE, SALARY, BONUS) VALUES ('A03', '우리', null, 1100, null);
INSERT INTO SALARY (ID, NAME, BONUS_TYPE, SALARY, BONUS) VALUES ('A04', '강산', null, 980, null);
INSERT INTO SALARY (ID, NAME, BONUS_TYPE, SALARY, BONUS) VALUES ('A05', '만세', 'FA', 990, 30);
create table student (
student_id number(10) ,
major_id number(10),
bl_prfs_id number(10),
name varchar2(20),
tel varchar2(15)
);
create table professor (
prfs_id number(10),
bl_major_id number(10),
name varchar2(20),
tel varchar2(15)
);
create table major (
major_id number(10),
major_title varchar2(30),
major_prfs_cnt number(5),
major_student_cnt number(5),
tel varchar2(15)
);
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1001, 9901, 7029901, '한지호', '01098447362');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1002, 9902, 7029902, '김은숙', '01023456787');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1003, 9903, 7039903, '강경호', '01092938476');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1004, 9904, 7049904, '민현민', '01088786623');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1005, 9905, 7059905, '조승우', '01092877795');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1006, 9901, 7069901, '이남철', '01045671234');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1007, 9902, 7079902, '이강철', '01021213434');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1008, 9903, 7089903, '조민수', '01098937262');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1009, 9904, 7099904, '박찬경', '01029884432');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1010, 9905, 7109905, '이도경', '01029385647');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1011, 9901, 7019901, '이만호', '01099996453');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1012, 9902, 7029902, '김효민', '01092887666');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1013, 9903, 7039903, '최효성', '01098999933');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1014, 9904, 7049904, '우민국', '01087651112');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1015, 9905, 7059905, '지대한', '01093934848');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1016, 9901, 7069901, '한나름', '01023329882');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1017, 9902, 7079902, '유육경', '01099881111');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1018, 9903, 7089903, '조민경', '01023311120');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1019, 9904, 7099904, '경지수', '01029100293');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1020, 9905, 7109905, '오종환', '01098882226');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1021, 9901, 7019901, '조형민', '01098909876');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1022, 9902, 7029902, '이수강', '01099992222');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1023, 9903, 7039903, '서민호', '01092997654');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1024, 9904, 7049904, '박효숙', '01022293332');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1025, 9905, 7059905, '남궁옥경', '01099938475');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1026, 9901, 7069901, '피경남', '01029222233');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1027, 9902, 7079902, '고주경', '01099226655');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1028, 9903, 7089903, '하지만', '01022228965');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1029, 9904, 7099904, '기지효', '01012090912');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1030, 9905, 7109905, '박민호', '01074746363');
INSERT INTO professor (prfs_id, bl_major_id, name, tel) VALUES (7019901, 9901, '김보경', '023445678');
INSERT INTO professor (prfs_id, bl_major_id, name, tel) VALUES (7029902, 9902, '조숙', '023446789');
INSERT INTO professor (prfs_id, bl_major_id, name, tel) VALUES (7039903, 9903, '이호', '023449584');
INSERT INTO professor (prfs_id, bl_major_id, name, tel) VALUES (7049904, 9904, '박철남', '023449588');
INSERT INTO professor (prfs_id, bl_major_id, name, tel) VALUES (7059905, 9905, '이만기', '023443443');
INSERT INTO professor (prfs_id, bl_major_id, name, tel) VALUES (7069901, 9901, '강조교', '023449994');
INSERT INTO professor (prfs_id, bl_major_id, name, tel) VALUES (7079902, 9902, '이희숙', '023443321');
INSERT INTO professor (prfs_id, bl_major_id, name, tel) VALUES (7089903, 9903, '소머리', '023440123');
INSERT INTO professor (prfs_id, bl_major_id, name, tel) VALUES (7099904, 9904, '두수위', '023443327');
INSERT INTO professor (prfs_id, bl_major_id, name, tel) VALUES (7109905, 9905, '지만래', '023449995');
INSERT INTO major (major_id, major_title, major_prfs_cnt, major_student_cnt, tel) VALUES (9901, '컴퓨터공학과', 7, 123, '023454321');
INSERT INTO major (major_id, major_title, major_prfs_cnt, major_student_cnt, tel) VALUES (9902, '아동보육학과', 8, 345, '023456676');
INSERT INTO major (major_id, major_title, major_prfs_cnt, major_student_cnt, tel) VALUES (9903, '국문학과', 6, 213, '023456567');
INSERT INTO major (major_id, major_title, major_prfs_cnt, major_student_cnt, tel) VALUES (9904, '경제학과', 5, 432, '023456987');
INSERT INTO major (major_id, major_title, major_prfs_cnt, major_student_cnt, tel) VALUES (9905, '사회복지학과', 9, 312, '023454534');
create table customer
( name varchar2(10),
point number);
create table gift
(
name varchar2(20) null,
point_s number null,
point_e number null
);
INSERT INTO customer (name, point) VALUES ('조성모', 5);
INSERT INTO customer (name, point) VALUES ('이기찬', 12);
INSERT INTO customer (name, point) VALUES ('이소라', 14);
INSERT INTO customer (name, point) VALUES ('서태지', 18);
INSERT INTO customer (name, point) VALUES ('박효신', 21);
INSERT INTO customer (name, point) VALUES ('김정민', 16);
INSERT INTO customer (name, point) VALUES ('양파', 9);
INSERT INTO customer (name, point) VALUES ('강수지', 22);
INSERT INTO customer (name, point) VALUES ('강타', 24);
INSERT INTO gift (name, point_s, point_e) VALUES ('공기청정기', 11, 15);
INSERT INTO gift (name, point_s, point_e) VALUES ('아이폰11', 21, 25);
INSERT INTO gift (name, point_s, point_e) VALUES ('로봇청소기', 6, 10);
INSERT INTO gift (name, point_s, point_e) VALUES ('상품권', 1, 5);
INSERT INTO gift (name, point_s, point_e) VALUES ('스마트패드', 16, 20);
create table COMPANY_DEPT
(
DEPT_CD VARCHAR2(8) not null
primary key,
UP_DEPT_CD VARCHAR2(8),
DEPT_NM VARCHAR2(50),
USE_YN CHAR,
REG_DTM DATE,
REG_USER VARCHAR2(30)
);
INSERT INTO COMPANY_DEPT (DEPT_CD, UP_DEPT_CD, DEPT_NM, USE_YN, REG_DTM, REG_USER) VALUES ('DC001', null, '대표이사', 'Y', TIMESTAMP '2022-12-23 12:28:57', 'admin');
INSERT INTO COMPANY_DEPT (DEPT_CD, UP_DEPT_CD, DEPT_NM, USE_YN, REG_DTM, REG_USER) VALUES ('DC002', 'DC001', '경영지원본부', 'Y', TIMESTAMP '2022-12-23 12:28:57', 'admin');
INSERT INTO COMPANY_DEPT (DEPT_CD, UP_DEPT_CD, DEPT_NM, USE_YN, REG_DTM, REG_USER) VALUES ('DC003', 'DC001', '시스템사업본부', 'Y', TIMESTAMP '2022-12-23 12:28:57', 'admin');
INSERT INTO COMPANY_DEPT (DEPT_CD, UP_DEPT_CD, DEPT_NM, USE_YN, REG_DTM, REG_USER) VALUES ('DC004', 'DC001', '개발사업부', 'N', TIMESTAMP '2022-12-23 12:28:57', 'admin');
INSERT INTO COMPANY_DEPT (DEPT_CD, UP_DEPT_CD, DEPT_NM, USE_YN, REG_DTM, REG_USER) VALUES ('DC005', 'DC002', '경영지원팀', 'Y', TIMESTAMP '2022-12-23 12:28:57', 'admin');
INSERT INTO COMPANY_DEPT (DEPT_CD, UP_DEPT_CD, DEPT_NM, USE_YN, REG_DTM, REG_USER) VALUES ('DC006', 'DC002', '구매조달팀', 'Y', TIMESTAMP '2022-12-23 12:28:57', 'admin');
INSERT INTO COMPANY_DEPT (DEPT_CD, UP_DEPT_CD, DEPT_NM, USE_YN, REG_DTM, REG_USER) VALUES ('DC007', 'DC003', '시스템영업팀', 'Y', TIMESTAMP '2022-12-23 12:28:57', 'admin');
INSERT INTO COMPANY_DEPT (DEPT_CD, UP_DEPT_CD, DEPT_NM, USE_YN, REG_DTM, REG_USER) VALUES ('DC008', 'DC003', '기술지원팀', 'Y', TIMESTAMP '2022-12-23 12:28:57', 'admin');
INSERT INTO COMPANY_DEPT (DEPT_CD, UP_DEPT_CD, DEPT_NM, USE_YN, REG_DTM, REG_USER) VALUES ('DC009', 'DC004', '보안개발', 'Y', TIMESTAMP '2022-12-23 12:28:57', 'admin');
INSERT INTO COMPANY_DEPT (DEPT_CD, UP_DEPT_CD, DEPT_NM, USE_YN, REG_DTM, REG_USER) VALUES ('DC010', 'DC004', 'SW개발', 'N', TIMESTAMP '2022-12-23 12:28:57', 'admin');
INSERT INTO COMPANY_DEPT (DEPT_CD, UP_DEPT_CD, DEPT_NM, USE_YN, REG_DTM, REG_USER) VALUES ('DC011', 'DC007', '영업관리', 'N', TIMESTAMP '2022-12-23 12:28:57', 'admin');
INSERT INTO COMPANY_DEPT (DEPT_CD, UP_DEPT_CD, DEPT_NM, USE_YN, REG_DTM, REG_USER) VALUES ('DC012', 'DC008', '기술교육', 'Y', TIMESTAMP '2022-12-23 12:28:57', 'admin');
create table EXAM_RESULT
(
CLASS_NUM NUMBER,
SUBJECT VARCHAR2(10),
STUDENT_NO NUMBER,
SCORE NUMBER
);
INSERT INTO EXAM_RESULT (CLASS_NUM, SUBJECT, STUDENT_NO, SCORE) VALUES (1, '수학', 100, 98);
INSERT INTO EXAM_RESULT (CLASS_NUM, SUBJECT, STUDENT_NO, SCORE) VALUES (1, '수학', 123, 100);
INSERT INTO EXAM_RESULT (CLASS_NUM, SUBJECT, STUDENT_NO, SCORE) VALUES (1, '영어', 234, 78);
INSERT INTO EXAM_RESULT (CLASS_NUM, SUBJECT, STUDENT_NO, SCORE) VALUES (1, '영어', 342, 87);
INSERT INTO EXAM_RESULT (CLASS_NUM, SUBJECT, STUDENT_NO, SCORE) VALUES (1, '국어', 443, 97);
INSERT INTO EXAM_RESULT (CLASS_NUM, SUBJECT, STUDENT_NO, SCORE) VALUES (1, '국어', 567, 67);
INSERT INTO EXAM_RESULT (CLASS_NUM, SUBJECT, STUDENT_NO, SCORE) VALUES (2, '수학', 764, 58);
INSERT INTO EXAM_RESULT (CLASS_NUM, SUBJECT, STUDENT_NO, SCORE) VALUES (2, '수학', 234, 96);
INSERT INTO EXAM_RESULT (CLASS_NUM, SUBJECT, STUDENT_NO, SCORE) VALUES (2, '영어', 345, 88);
INSERT INTO EXAM_RESULT (CLASS_NUM, SUBJECT, STUDENT_NO, SCORE) VALUES (2, '영어', 547, 90);
INSERT INTO EXAM_RESULT (CLASS_NUM, SUBJECT, STUDENT_NO, SCORE) VALUES (2, '국어', 567, 60);
INSERT INTO EXAM_RESULT (CLASS_NUM, SUBJECT, STUDENT_NO, SCORE) VALUES (2, '국어', 998, 100);
INSERT INTO EXAM_RESULT (CLASS_NUM, SUBJECT, STUDENT_NO, SCORE) VALUES (3, '수학', 441, 100);
INSERT INTO EXAM_RESULT (CLASS_NUM, SUBJECT, STUDENT_NO, SCORE) VALUES (3, '수학', 114, 87);
INSERT INTO EXAM_RESULT (CLASS_NUM, SUBJECT, STUDENT_NO, SCORE) VALUES (3, '영어', 231, 66);
INSERT INTO EXAM_RESULT (CLASS_NUM, SUBJECT, STUDENT_NO, SCORE) VALUES (3, '영어', 546, 79);
INSERT INTO EXAM_RESULT (CLASS_NUM, SUBJECT, STUDENT_NO, SCORE) VALUES (3, '국어', 728, 87);
INSERT INTO EXAM_RESULT (CLASS_NUM, SUBJECT, STUDENT_NO, SCORE) VALUES (3, '국어', 566, 70), Original SQL = create table country
(
country_name varchar(100),
capital_city varchar(100),
continent varchar(100)
);
INSERT INTO country (country_name, capital_city, continent) VALUES ('USA', 'Washington', 'America');
INSERT INTO country (country_name, capital_city, continent) VALUES ('England', 'London', 'Europe');
INSERT INTO country (country_name, capital_city, continent) VALUES ('S.Korea', ' Seoul', 'Asia');
INSERT INTO country (country_name, capital_city, continent) VALUES ('Australia', ' Canberra', 'Oceania');
INSERT INTO country (country_name, capital_city, continent) VALUES ('Ghana', 'Accra', 'Africa');
INSERT INTO country (country_name, capital_city, continent) VALUES ('Argentina', 'Buenos aires', 'America');
create table budget
(
do varchar(100) null,
city varchar(100) null,
budget_value int null,
population int null
);
INSERT INTO budget (do, city, budget_value, population) VALUES ('서울특별시', '서울특별시', 23324, 345);
INSERT INTO budget (do, city, budget_value, population) VALUES ('부산광역시', '부산광역시', 34323, 5345);
INSERT INTO budget (do, city, budget_value, population) VALUES ('경상남도', '창원시', 4331, 435);
INSERT INTO budget (do, city, budget_value, population) VALUES ('경상남도', '양산시', 25436, 2134);
INSERT INTO budget (do, city, budget_value, population) VALUES ('경상남도', '밀양시', 62341, 6523);
INSERT INTO budget (do, city, budget_value, population) VALUES ('경기도', '부천시', 3242, 345);
INSERT INTO budget (do, city, budget_value, population) VALUES ('경기도', '시흥시', 32454, 546);
INSERT INTO budget (do, city, budget_value, population) VALUES ('경기도', '수원시', 3234, 345);
INSERT INTO budget (do, city, budget_value, population) VALUES ('충청남도', '공주시', 2425, 436);
INSERT INTO budget (do, city, budget_value, population) VALUES ('충청남도', '논산시', 5534, 4567);
INSERT INTO budget (do, city, budget_value, population) VALUES ('강원도', '속초시', 6542, 3542);
INSERT INTO budget (do, city, budget_value, population) VALUES ('강원도', '강릉시', 23423, 4355);
INSERT INTO budget (do, city, budget_value, population) VALUES ('강원도', '태백시', 5465, 45);
INSERT INTO budget (do, city, budget_value, population) VALUES ('전라북도', '전주시', 456, 645);
INSERT INTO budget (do, city, budget_value, population) VALUES ('전라북도', '군산시', 3243, 234);
create table salary
(
id varchar2(10),
name varchar2(100),
bonus_type varchar2(3),
salary number,
bonus number
);
INSERT INTO SALARY (ID, NAME, BONUS_TYPE, SALARY, BONUS) VALUES ('A01', '대한', 'AB', 1000, 100);
INSERT INTO SALARY (ID, NAME, BONUS_TYPE, SALARY, BONUS) VALUES ('A02', '민국', 'AC', 1300, 90);
INSERT INTO SALARY (ID, NAME, BONUS_TYPE, SALARY, BONUS) VALUES ('A03', '우리', null, 1100, null);
INSERT INTO SALARY (ID, NAME, BONUS_TYPE, SALARY, BONUS) VALUES ('A04', '강산', null, 980, null);
INSERT INTO SALARY (ID, NAME, BONUS_TYPE, SALARY, BONUS) VALUES ('A05', '만세', 'FA', 990, 30);
create table student (
student_id number(10) ,
major_id number(10),
bl_prfs_id number(10),
name varchar2(20),
tel varchar2(15)
);
create table professor (
prfs_id number(10),
bl_major_id number(10),
name varchar2(20),
tel varchar2(15)
);
create table major (
major_id number(10),
major_title varchar2(30),
major_prfs_cnt number(5),
major_student_cnt number(5),
tel varchar2(15)
);
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1001, 9901, 7029901, '한지호', '01098447362');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1002, 9902, 7029902, '김은숙', '01023456787');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1003, 9903, 7039903, '강경호', '01092938476');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1004, 9904, 7049904, '민현민', '01088786623');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1005, 9905, 7059905, '조승우', '01092877795');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1006, 9901, 7069901, '이남철', '01045671234');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1007, 9902, 7079902, '이강철', '01021213434');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1008, 9903, 7089903, '조민수', '01098937262');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1009, 9904, 7099904, '박찬경', '01029884432');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1010, 9905, 7109905, '이도경', '01029385647');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1011, 9901, 7019901, '이만호', '01099996453');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1012, 9902, 7029902, '김효민', '01092887666');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1013, 9903, 7039903, '최효성', '01098999933');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1014, 9904, 7049904, '우민국', '01087651112');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1015, 9905, 7059905, '지대한', '01093934848');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1016, 9901, 7069901, '한나름', '01023329882');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1017, 9902, 7079902, '유육경', '01099881111');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1018, 9903, 7089903, '조민경', '01023311120');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1019, 9904, 7099904, '경지수', '01029100293');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1020, 9905, 7109905, '오종환', '01098882226');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1021, 9901, 7019901, '조형민', '01098909876');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1022, 9902, 7029902, '이수강', '01099992222');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1023, 9903, 7039903, '서민호', '01092997654');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1024, 9904, 7049904, '박효숙', '01022293332');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1025, 9905, 7059905, '남궁옥경', '01099938475');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1026, 9901, 7069901, '피경남', '01029222233');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1027, 9902, 7079902, '고주경', '01099226655');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1028, 9903, 7089903, '하지만', '01022228965');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1029, 9904, 7099904, '기지효', '01012090912');
INSERT INTO student (student_id, major_id, bl_prfs_id, name, tel) VALUES (1030, 9905, 7109905, '박민호', '01074746363');
INSERT INTO professor (prfs_id, bl_major_id, name, tel) VALUES (7019901, 9901, '김보경', '023445678');
INSERT INTO professor (prfs_id, bl_major_id, name, tel) VALUES (7029902, 9902, '조숙', '023446789');
INSERT INTO professor (prfs_id, bl_major_id, name, tel) VALUES (7039903, 9903, '이호', '023449584');
INSERT INTO professor (prfs_id, bl_major_id, name, tel) VALUES (7049904, 9904, '박철남', '023449588');
INSERT INTO professor (prfs_id, bl_major_id, name, tel) VALUES (7059905, 9905, '이만기', '023443443');
INSERT INTO professor (prfs_id, bl_major_id, name, tel) VALUES (7069901, 9901, '강조교', '023449994');
INSERT INTO professor (prfs_id, bl_major_id, name, tel) VALUES (7079902, 9902, '이희숙', '023443321');
INSERT INTO professor (prfs_id, bl_major_id, name, tel) VALUES (7089903, 9903, '소머리', '023440123');
INSERT INTO professor (prfs_id, bl_major_id, name, tel) VALUES (7099904, 9904, '두수위', '023443327');
INSERT INTO professor (prfs_id, bl_major_id, name, tel) VALUES (7109905, 9905, '지만래', '023449995');
INSERT INTO major (major_id, major_title, major_prfs_cnt, major_student_cnt, tel) VALUES (9901, '컴퓨터공학과', 7, 123, '023454321');
INSERT INTO major (major_id, major_title, major_prfs_cnt, major_student_cnt, tel) VALUES (9902, '아동보육학과', 8, 345, '023456676');
INSERT INTO major (major_id, major_title, major_prfs_cnt, major_student_cnt, tel) VALUES (9903, '국문학과', 6, 213, '023456567');
INSERT INTO major (major_id, major_title, major_prfs_cnt, major_student_cnt, tel) VALUES (9904, '경제학과', 5, 432, '023456987');
INSERT INTO major (major_id, major_title, major_prfs_cnt, major_student_cnt, tel) VALUES (9905, '사회복지학과', 9, 312, '023454534');
create table customer
( name varchar2(10),
point number);
create table gift
(
name varchar2(20) null,
point_s number null,
point_e number null
);
INSERT INTO customer (name, point) VALUES ('조성모', 5);
INSERT INTO customer (name, point) VALUES ('이기찬', 12);
INSERT INTO customer (name, point) VALUES ('이소라', 14);
INSERT INTO customer (name, point) VALUES ('서태지', 18);
INSERT INTO customer (name, point) VALUES ('박효신', 21);
INSERT INTO customer (name, point) VALUES ('김정민', 16);
INSERT INTO customer (name, point) VALUES ('양파', 9);
INSERT INTO customer (name, point) VALUES ('강수지', 22);
INSERT INTO customer (name, point) VALUES ('강타', 24);
INSERT INTO gift (name, point_s, point_e) VALUES ('공기청정기', 11, 15);
INSERT INTO gift (name, point_s, point_e) VALUES ('아이폰11', 21, 25);
INSERT INTO gift (name, point_s, point_e) VALUES ('로봇청소기', 6, 10);
INSERT INTO gift (name, point_s, point_e) VALUES ('상품권', 1, 5);
INSERT INTO gift (name, point_s, point_e) VALUES ('스마트패드', 16, 20);
create table COMPANY_DEPT
(
DEPT_CD VARCHAR2(8) not null
primary key,
UP_DEPT_CD VARCHAR2(8),
DEPT_NM VARCHAR2(50),
USE_YN CHAR,
REG_DTM DATE,
REG_USER VARCHAR2(30)
);
INSERT INTO COMPANY_DEPT (DEPT_CD, UP_DEPT_CD, DEPT_NM, USE_YN, REG_DTM, REG_USER) VALUES ('DC001', null, '대표이사', 'Y', TIMESTAMP '2022-12-23 12:28:57', 'admin');
INSERT INTO COMPANY_DEPT (DEPT_CD, UP_DEPT_CD, DEPT_NM, USE_YN, REG_DTM, REG_USER) VALUES ('DC002', 'DC001', '경영지원본부', 'Y', TIMESTAMP '2022-12-23 12:28:57', 'admin');
INSERT INTO COMPANY_DEPT (DEPT_CD, UP_DEPT_CD, DEPT_NM, USE_YN, REG_DTM, REG_USER) VALUES ('DC003', 'DC001', '시스템사업본부', 'Y', TIMESTAMP '2022-12-23 12:28:57', 'admin');
INSERT INTO COMPANY_DEPT (DEPT_CD, UP_DEPT_CD, DEPT_NM, USE_YN, REG_DTM, REG_USER) VALUES ('DC004', 'DC001', '개발사업부', 'N', TIMESTAMP '2022-12-23 12:28:57', 'admin');
INSERT INTO COMPANY_DEPT (DEPT_CD, UP_DEPT_CD, DEPT_NM, USE_YN, REG_DTM, REG_USER) VALUES ('DC005', 'DC002', '경영지원팀', 'Y', TIMESTAMP '2022-12-23 12:28:57', 'admin');
INSERT INTO COMPANY_DEPT (DEPT_CD, UP_DEPT_CD, DEPT_NM, USE_YN, REG_DTM, REG_USER) VALUES ('DC006', 'DC002', '구매조달팀', 'Y', TIMESTAMP '2022-12-23 12:28:57', 'admin');
INSERT INTO COMPANY_DEPT (DEPT_CD, UP_DEPT_CD, DEPT_NM, USE_YN, REG_DTM, REG_USER) VALUES ('DC007', 'DC003', '시스템영업팀', 'Y', TIMESTAMP '2022-12-23 12:28:57', 'admin');
INSERT INTO COMPANY_DEPT (DEPT_CD, UP_DEPT_CD, DEPT_NM, USE_YN, REG_DTM, REG_USER) VALUES ('DC008', 'DC003', '기술지원팀', 'Y', TIMESTAMP '2022-12-23 12:28:57', 'admin');
INSERT INTO COMPANY_DEPT (DEPT_CD, UP_DEPT_CD, DEPT_NM, USE_YN, REG_DTM, REG_USER) VALUES ('DC009', 'DC004', '보안개발', 'Y', TIMESTAMP '2022-12-23 12:28:57', 'admin');
INSERT INTO COMPANY_DEPT (DEPT_CD, UP_DEPT_CD, DEPT_NM, USE_YN, REG_DTM, REG_USER) VALUES ('DC010', 'DC004', 'SW개발', 'N', TIMESTAMP '2022-12-23 12:28:57', 'admin');
INSERT INTO COMPANY_DEPT (DEPT_CD, UP_DEPT_CD, DEPT_NM, USE_YN, REG_DTM, REG_USER) VALUES ('DC011', 'DC007', '영업관리', 'N', TIMESTAMP '2022-12-23 12:28:57', 'admin');
INSERT INTO COMPANY_DEPT (DEPT_CD, UP_DEPT_CD, DEPT_NM, USE_YN, REG_DTM, REG_USER) VALUES ('DC012', 'DC008', '기술교육', 'Y', TIMESTAMP '2022-12-23 12:28:57', 'admin');
create table EXAM_RESULT
(
CLASS_NUM NUMBER,
SUBJECT VARCHAR2(10),
STUDENT_NO NUMBER,
SCORE NUMBER
);
INSERT INTO EXAM_RESULT (CLASS_NUM, SUBJECT, STUDENT_NO, SCORE) VALUES (1, '수학', 100, 98);
INSERT INTO EXAM_RESULT (CLASS_NUM, SUBJECT, STUDENT_NO, SCORE) VALUES (1, '수학', 123, 100);
INSERT INTO EXAM_RESULT (CLASS_NUM, SUBJECT, STUDENT_NO, SCORE) VALUES (1, '영어', 234, 78);
INSERT INTO EXAM_RESULT (CLASS_NUM, SUBJECT, STUDENT_NO, SCORE) VALUES (1, '영어', 342, 87);
INSERT INTO EXAM_RESULT (CLASS_NUM, SUBJECT, STUDENT_NO, SCORE) VALUES (1, '국어', 443, 97);
INSERT INTO EXAM_RESULT (CLASS_NUM, SUBJECT, STUDENT_NO, SCORE) VALUES (1, '국어', 567, 67);
INSERT INTO EXAM_RESULT (CLASS_NUM, SUBJECT, STUDENT_NO, SCORE) VALUES (2, '수학', 764, 58);
INSERT INTO EXAM_RESULT (CLASS_NUM, SUBJECT, STUDENT_NO, SCORE) VALUES (2, '수학', 234, 96);
INSERT INTO EXAM_RESULT (CLASS_NUM, SUBJECT, STUDENT_NO, SCORE) VALUES (2, '영어', 345, 88);
INSERT INTO EXAM_RESULT (CLASS_NUM, SUBJECT, STUDENT_NO, SCORE) VALUES (2, '영어', 547, 90);
INSERT INTO EXAM_RESULT (CLASS_NUM, SUBJECT, STUDENT_NO, SCORE) VALUES (2, '국어', 567, 60);
INSERT INTO EXAM_RESULT (CLASS_NUM, SUBJECT, STUDENT_NO, SCORE) VALUES (2, '국어', 998, 100);
INSERT INTO EXAM_RESULT (CLASS_NUM, SUBJECT, STUDENT_NO, SCORE) VALUES (3, '수학', 441, 100);
INSERT INTO EXAM_RESULT (CLASS_NUM, SUBJECT, STUDENT_NO, SCORE) VALUES (3, '수학', 114, 87);
INSERT INTO EXAM_RESULT (CLASS_NUM, SUBJECT, STUDENT_NO, SCORE) VALUES (3, '영어', 231, 66);
INSERT INTO EXAM_RESULT (CLASS_NUM, SUBJECT, STUDENT_NO, SCORE) VALUES (3, '영어', 546, 79);
INSERT INTO EXAM_RESULT (CLASS_NUM, SUBJECT, STUDENT_NO, SCORE) VALUES (3, '국어', 728, 87);
INSERT INTO EXAM_RESULT (CLASS_NUM, SUBJECT, STUDENT_NO, SCORE) VALUES (3, '국어', 566, 70), Error Message = ORA-00922: 누락된 또는 부적합한 옵션
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:710)
... 27 more
댓글
해당부분은 에디터에서 어떻게 선택하고 어떤 버튼을 눌렀는지 확인이 필요합니다.
댓글을 남기려면 로그인하세요.