Student, Department, Professor, gift, customer 샘플 테이블 데이터

SALGRADE는 아래걸 쓰자.

CREATE TABLE SALGRADE

(GRADE NUMBER(2),

LOSAL NUMBER(5),

HISAL NUMBER(5));

 

INSERT INTO SALGRADE VALUES (1, 700, 1200);

INSERT INTO SALGRADE VALUES (2, 1201, 1400);

INSERT INTO SALGRADE VALUES (3, 1401, 2000);

INSERT INTO SALGRADE VALUES (4, 2001, 3000);

INSERT INTO SALGRADE VALUES (5, 3001, 9999);

create table gift

( gno number ,

gname varchar2(20) ,

g_start number ,

g_end number );

 

 

insert into gift values(1,'참치세트',1,100000);

insert into gift values(2,'샴푸세트',100001,200000);

insert into gift values(3,'세차용품세트',200001,300000);

insert into gift values(4,'주방용품세트',300001,400000);

insert into gift values(5,'산악용자전거',400001,500000);

insert into gift values(6,'LCD모니터',500001,600000);

insert into gift values(7,'노트북',600001,700000);

insert into gift values(8,'벽걸이TV',700001,800000);

insert into gift values(9,'드럼세탁기',800001,900000);

insert into gift values(10,'양쪽문냉장고',900001,1000000);

commit ;

 

create table customer

( gno number(8) ,

gname varchar2(30) ,

jumin char(13) ,

point number );

 

insert into customer values(1,'김오징어','1111111111111',65000);

insert into customer values(2,'김수환무','2222221222222',73000);

insert into customer values(3,'나건달' ,'3333331333333',99000);

 

 

 

실습데이터_Student.rtf

0.01MB