ulvis.paste.net

Paste Search Dynamic
Recent pastes
CREATE TABLE INF
  1. create table INF(
  2.         EMP_NO CHAR(8) primary key,
  3.         GRADE_NUM NUMBER not null);
  4. create table CHART(
  5.         NUM_LIST NUMBER primary key,
  6.         NUM_GRADE VARCHAR(16) not null);
  7. create table INF_NAME(
  8.         EMP_NUM CHAR(8) primary key,
  9.         EMP_NAME VARCHAR(25) not null);
  10.        
  11. insert into CHART values(1,'HIGH');
  12. insert into CHART values(2,'MID');
  13. insert into CHART values(3,'LOW');
  14.  
  15. insert into INF values('2192001',2);
  16. insert into INF values('2192002',3);
  17. insert into INF values('2192003',3);
  18. insert into INF values('2181002',1);
  19.  
  20. insert into INF_NAME values('2181002','JUNG WUJUN');
  21. insert into INF_NAME values('2192001','GWACK TAEMIN');
  22. insert into INF_NAME values('2192002','KIM KITAE');
  23. insert into INF_NAME values('2192003','KIM TAEWU');
  24.  
  25. select A.EMP_NO from INF A;
  26.  
  27. select A.EMP_NO, C.EMP_NAME, A.GRADE_NUM, B.NUM_GRADE
  28. from INF A, CHART B, INF_NAME C
  29. where A.EMP_NO = C.EMP_NUM and A.GRADE_NUM = B.NUM_GRADE;
  30.  
  31.  
Parsed in 0.013 seconds