CREATE TABLE Dept ( Number (2), VARCHAR2, VARCHAR2 ());
CREATE TABLEEMP (empno Number(4), enameVARCHAR2(Ten), JobVARCHAR2(9), Mgr Number(4), HireDate DATE, Sal Number(7,2), Comm Number(7,2), Deptno Number(2));
INSERT intoDeptVALUES(Ten,'ACCOUNTING','NEW YORK');INSERT intoDeptVALUES( -,' the','DALLAS');INSERT intoDeptVALUES( -,'SALES','CHICAGO');INSERT intoDeptVALUES( +,'OPERATIONS','BOSTON');INSERT intoEmpVALUES(7369,'SMITH','Clerk',7902, To_date ('17-12-1980','dd-mm-yyyy'), -,NULL, -);INSERT intoEmpVALUES(7499,'ALLEN','salesman',7698, To_date ('20-2-1981','dd-mm-yyyy'), the, -, -);INSERT intoEmpVALUES(7521,'WARD','salesman',7698, To_date ('22-2-1981','dd-mm-yyyy'),1250, -, -);INSERT intoEmpVALUES(7566,'JONES','MANAGER',7839, To_date ('2-4-1981','dd-mm-yyyy'),2975,NULL, -);INSERT intoEmpVALUES(7654,'MARTIN','salesman',7698, To_date ('28-9-1981','dd-mm-yyyy'),1250,1400, -);INSERT intoEmpVALUES(7698,'BLAKE','MANAGER',7839, To_date ('1-5-1981','dd-mm-yyyy'),2850,NULL, -);INSERT intoEmpVALUES(7782,'CLARK','MANAGER',7839, To_date ('9-6-1981','dd-mm-yyyy'),2450,NULL,Ten);INSERT intoEmpVALUES(7788,'SCOTT','ANALYST',7566, To_date ('19-4-87','dd-mm-yyyy'), the,NULL, -);INSERT intoEmpVALUES(7839,'KING','President',NULL, To_date ('17-11-1981','dd-mm-yyyy'), the,NULL,Ten);INSERT intoEmpVALUES(7844,'TURNER','salesman',7698, To_date ('8-9-1981','dd-mm-yyyy'), the,0, -);INSERT intoEmpVALUES(7876,'ADAMS','Clerk',7788, To_date ('23-5-87','dd-mm-yyyy'),1100,NULL, -);INSERT intoEmpVALUES(7900,'JAMES','Clerk',7698, To_date ('3-12-1981','dd-mm-yyyy'),950,NULL, -);INSERT intoEmpVALUES(7902,'FORD','ANALYST',7566, To_date ('3-12-1981','dd-mm-yyyy'), the,NULL, -);INSERT intoEmpVALUES(7934,'MILLER','Clerk',7782, To_date ('23-1-1982','dd-mm-yyyy'),1300,NULL,Ten);
Oracle Learning Note series------dedicated tables for Oracle operational examples