API tools faq
paste
View difference between Paste ID: ZKGhaHPe and upTmtsNV
SHOW: | | - or go back to the newest paste.
1
-- Screen-shot of my on-the-cloud database: http://yfrog.com/h265ynp :P
2-
--...This file is just the exported data from the database lab, have fun!!
2+
-- ...This file is just the exported data from the database lab, have fun!!
3
4-
--------------------------------------------------------

4+
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

5
--  File created - «·√Õœ-œÌ”„»—-11-2011   

6-
--------------------------------------------------------

6+
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

7
8-
--------------------------------------------------------

8+
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

9
--  DDL for Table BONUS

10-
--------------------------------------------------------

10+
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

11
12-
  CREATE TABLE "BONUS" 

12+
  CREATE TABLE BONUS

13-
   (	"ENAME" VARCHAR2(10), 

13+
   (	ENAME VARCHAR(10), 

14-
	"JOB" VARCHAR2(9), 

14+
	JOB VARCHAR(9), 

15-
	"SAL" NUMBER, 

15+
	SAL INT, 

16-
	"COMM" NUMBER

16+
	COMM INT

17
   ) ;

18
 

19-
--------------------------------------------------------

19+
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

20
--  DDL for Table EMP

21-
--------------------------------------------------------

21+
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

22
23-
  CREATE TABLE "EMP" 

23+
  CREATE TABLE EMP 

24-
   (	"EMPNO" NUMBER(4,0), 

24+
   (	EMPNO INT(4,0), 

25-
	"ENAME" VARCHAR2(10), 

25+
	ENAME VARCHAR(10), 

26-
	"JOB" VARCHAR2(9), 

26+
	JOB VARCHAR(9), 

27-
	"MGR" NUMBER(4,0), 

27+
	MGR INT(4,0), 

28-
	"HIREDATE" DATE, 

28+
	HIREDATE DATE, 

29-
	"SAL" NUMBER(7,2), 

29+
	SAL INT(7,2), 

30-
	"COMM" NUMBER(7,2), 

30+
	COMM INT(7,2), 

31-
	"DEPTNO" NUMBER(2,0), 

31+
	DEPTNO INT(2,0), 

32-
	 CONSTRAINT "PK_EMP" PRIMARY KEY ("EMPNO") ENABLE, 

32+
	 CONSTRAINT PK_EMP PRIMARY KEY (EMPNO) ENABLE, 

33-
	 CONSTRAINT "FK_DEPTNO" FOREIGN KEY ("DEPTNO")

33+
	 CONSTRAINT FK_DEPTNO FOREIGN KEY (DEPTNO)

34-
	  REFERENCES "DEPT" ("DEPTNO") ENABLE

34+
	  REFERENCES DEPT (DEPTNO) ENABLE

35
   ) ;

36
 

37-
--------------------------------------------------------

37+
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

38
--  DDL for Table DEPT

39-
--------------------------------------------------------

39+
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

40
41-
  CREATE TABLE "DEPT" 

41+
  CREATE TABLE DEPT 

42-
   (	"DEPTNO" NUMBER(2,0), 

42+
   (	DEPTNO INT(2,0), 

43-
	"DNAME" VARCHAR2(14), 

43+
	DNAME VARCHAR(14), 

44-
	"LOC" VARCHAR2(13), 

44+
	LOC VARCHAR(13), 

45-
	 CONSTRAINT "PK_DEPT" PRIMARY KEY ("DEPTNO") ENABLE

45+
	 CONSTRAINT PK_DEPT PRIMARY KEY (DEPTNO) ENABLE

46
   ) ;

47
 

48-
--------------------------------------------------------

48+
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

49
--  DDL for Table SALGRADE

50-
--------------------------------------------------------

50+
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

51
52-
  CREATE TABLE "SALGRADE" 

52+
  CREATE TABLE SALGRADE 

53-
   (	"GRADE" NUMBER, 

53+
   (	GRADE INT, 

54-
	"LOSAL" NUMBER, 

54+
	LOSAL INT, 

55-
	"HISAL" NUMBER

55+
	HISAL INT

56
   ) ;

57
 

58-
--------------------------------------------------------

58+
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

59
--  Constraints for Table EMP

60-
--------------------------------------------------------

60+
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

61
62-
  ALTER TABLE "EMP" ADD CONSTRAINT "PK_EMP" PRIMARY KEY ("EMPNO") ENABLE;

62+
  ALTER TABLE EMP ADD CONSTRAINT PK_EMP PRIMARY KEY (EMPNO) ENABLE;

63
 

64-
--------------------------------------------------------

64+
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

65
--  Constraints for Table DEPT

66-
--------------------------------------------------------

66+
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

67
68-
  ALTER TABLE "DEPT" ADD CONSTRAINT "PK_DEPT" PRIMARY KEY ("DEPTNO") ENABLE;

68+
  ALTER TABLE DEPT ADD CONSTRAINT PK_DEPT PRIMARY KEY (DEPTNO) ENABLE;

69
 

70-
--------------------------------------------------------

70+
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

71
--  DDL for Index PK_EMP

72-
--------------------------------------------------------

72+
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

73
74-
  CREATE UNIQUE INDEX "PK_EMP" ON "EMP" ("EMPNO") 

74+
  CREATE UNIQUE INDEX PK_EMP ON EMP (EMPNO) 

75
  ;

76
 

77-
--------------------------------------------------------

77+
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

78
--  DDL for Index PK_DEPT

79-
--------------------------------------------------------

79+
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

80
81-
  CREATE UNIQUE INDEX "PK_DEPT" ON "DEPT" ("DEPTNO") 

81+
  CREATE UNIQUE INDEX PK_DEPT ON DEPT (DEPTNO) 

82
  ;

83
 

84-
--------------------------------------------------------

84+
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

85
--  Ref Constraints for Table EMP

86-
--------------------------------------------------------

86+
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

87
88-
  ALTER TABLE "EMP" ADD CONSTRAINT "FK_DEPTNO" FOREIGN KEY ("DEPTNO")

88+
  ALTER TABLE EMP ADD CONSTRAINT FK_DEPTNO FOREIGN KEY (DEPTNO)

89-
	  REFERENCES "DEPT" ("DEPTNO") ENABLE;

89+
	  REFERENCES DEPT (DEPTNO) ENABLE;

90
 

91
---------------------------------------------------

92
--   DATA FOR TABLE BONUS

93
--   FILTER = none used

94
---------------------------------------------------

95
REM INSERTING into BONUS

96
97
---------------------------------------------------

98
--   END DATA FOR TABLE BONUS

99
---------------------------------------------------

100
101
---------------------------------------------------

102
--   DATA FOR TABLE EMP

103
--   FILTER = none used

104
---------------------------------------------------

105
REM INSERTING into EMP

106
Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7369,'SMITH','CLERK',7902,to_timestamp('1980-12-17 00:00:00.0','DD/MM/RR HH12:MI:SSXFF PM'),800,null,20);

107
Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7499,'ALLEN','SALESMAN',7698,to_timestamp('1981-02-20 00:00:00.0','DD/MM/RR HH12:MI:SSXFF PM'),1600,300,30);

108
Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7521,'WARD','SALESMAN',7698,to_timestamp('1981-02-22 00:00:00.0','DD/MM/RR HH12:MI:SSXFF PM'),1250,500,30);

109
Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7566,'JONES','MANAGER',7839,to_timestamp('1981-04-02 00:00:00.0','DD/MM/RR HH12:MI:SSXFF PM'),2975,null,20);

110
Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7654,'MARTIN','SALESMAN',7698,to_timestamp('1981-09-28 00:00:00.0','DD/MM/RR HH12:MI:SSXFF PM'),1250,1400,30);

111
Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7698,'BLAKE','MANAGER',7839,to_timestamp('1981-05-01 00:00:00.0','DD/MM/RR HH12:MI:SSXFF PM'),2850,null,30);

112
Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7782,'CLARK','MANAGER',7839,to_timestamp('1981-06-09 00:00:00.0','DD/MM/RR HH12:MI:SSXFF PM'),2450,null,10);

113
Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7788,'SCOTT','ANALYST',7566,to_timestamp('1987-04-19 00:00:00.0','DD/MM/RR HH12:MI:SSXFF PM'),3000,null,20);

114
Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7839,'KING','PRESIDENT',null,to_timestamp('1981-11-17 00:00:00.0','DD/MM/RR HH12:MI:SSXFF PM'),5000,null,10);

115
Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7844,'TURNER','SALESMAN',7698,to_timestamp('1981-09-08 00:00:00.0','DD/MM/RR HH12:MI:SSXFF PM'),1500,0,30);

116
Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7876,'ADAMS','CLERK',7788,to_timestamp('1987-05-23 00:00:00.0','DD/MM/RR HH12:MI:SSXFF PM'),1100,null,20);

117
Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7900,'JAMES','CLERK',7698,to_timestamp('1981-12-03 00:00:00.0','DD/MM/RR HH12:MI:SSXFF PM'),950,null,30);

118
Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7902,'FORD','ANALYST',7566,to_timestamp('1981-12-03 00:00:00.0','DD/MM/RR HH12:MI:SSXFF PM'),3000,null,20);

119
Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7934,'MILLER','CLERK',7782,to_timestamp('1982-01-23 00:00:00.0','DD/MM/RR HH12:MI:SSXFF PM'),1300,null,10);

120
121
---------------------------------------------------

122
--   END DATA FOR TABLE EMP

123
---------------------------------------------------

124
125
---------------------------------------------------

126
--   DATA FOR TABLE DEPT

127
--   FILTER = none used

128
---------------------------------------------------

129
REM INSERTING into DEPT

130
Insert into DEPT (DEPTNO,DNAME,LOC) values (10,'ACCOUNTING','NEW YORK');

131
Insert into DEPT (DEPTNO,DNAME,LOC) values (20,'RESEARCH','DALLAS');

132
Insert into DEPT (DEPTNO,DNAME,LOC) values (30,'SALES','CHICAGO');

133
Insert into DEPT (DEPTNO,DNAME,LOC) values (40,'OPERATIONS','BOSTON');

134
135
---------------------------------------------------

136
--   END DATA FOR TABLE DEPT

137
---------------------------------------------------

138
139
---------------------------------------------------

140
--   DATA FOR TABLE SALGRADE

141
--   FILTER = none used

142
---------------------------------------------------

143
REM INSERTING into SALGRADE

144
Insert into SALGRADE (GRADE,LOSAL,HISAL) values (1,700,1200);

145
Insert into SALGRADE (GRADE,LOSAL,HISAL) values (2,1201,1400);

146
Insert into SALGRADE (GRADE,LOSAL,HISAL) values (3,1401,2000);

147
Insert into SALGRADE (GRADE,LOSAL,HISAL) values (4,2001,3000);

148
Insert into SALGRADE (GRADE,LOSAL,HISAL) values (5,3001,9999);

149
150
---------------------------------------------------

151
--   END DATA FOR TABLE SALGRADE

152
---------------------------------------------------
        

    


            


                                


        

            



                
    

        Public Pastes
    

    
            

    

                    

        

    





    


    
    
    
    
    
    
    
    




    


    



                

            We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.             OK, I Understand
        

    
                

            

                
                    
                
            

            

                Not a member of Pastebin yet?

                Sign Up, it unlocks many cool features!