Demo Tables in Oracle SQL

 Employee Table Creation and Insertion Scripts in Oracle SQL

===========================================================

CREATE TABLE EMP

       (

EMPNO NUMBER(4) NOT NULL,

        ENAME VARCHAR2(10),

        JOB VARCHAR2(9),

        MGR NUMBER(4),

        HIREDATE DATE,

        SAL NUMBER(7, 2),

        COMM NUMBER(7, 2),

        DEPTNO NUMBER(2));

INSERT ALL

  INTO EMP VALUES (7369, 'SMITH',  'CLERK',     7902, TO_DATE('17-DEC-1980', 'DD-MON-YYYY'), 800,  NULL, 20)

  INTO EMP VALUES (7499, 'ALLEN',  'SALESMAN',  7698, TO_DATE('20-FEB-1981', 'DD-MON-YYYY'), 1600, 300,  30)

  INTO EMP VALUES (7521, 'WARD',   'SALESMAN',  7698, TO_DATE('22-FEB-1981', 'DD-MON-YYYY'), 1250, 500,  30)

  INTO EMP VALUES (7566, 'JONES',  'MANAGER',   7839, TO_DATE('02-APR-1981', 'DD-MON-YYYY'), 2975, NULL, 20)

  INTO EMP VALUES (7654, 'MARTIN', 'SALESMAN',  7698, TO_DATE('28-SEP-1981', 'DD-MON-YYYY'), 1250, 1400, 30)

  INTO EMP VALUES (7698, 'BLAKE',  'MANAGER',   7839, TO_DATE('01-MAY-1981', 'DD-MON-YYYY'), 2850, NULL, 30)

  INTO EMP VALUES (7782, 'CLARK',  'MANAGER',   7839, TO_DATE('09-JUN-1981', 'DD-MON-YYYY'), 2450, NULL, 10)

  INTO EMP VALUES (7788, 'SCOTT',  'ANALYST',   7566, TO_DATE('09-DEC-1982', 'DD-MON-YYYY'), 3000, NULL, 20)

  INTO EMP VALUES (7839, 'KING',   'PRESIDENT', NULL, TO_DATE('17-NOV-1981', 'DD-MON-YYYY'), 5000, NULL, 10)

  INTO EMP VALUES (7844, 'TURNER', 'SALESMAN',  7698, TO_DATE('08-SEP-1981', 'DD-MON-YYYY'), 1500, 0,    30)

  INTO EMP VALUES (7876, 'ADAMS',  'CLERK',     7788, TO_DATE('12-JAN-1983', 'DD-MON-YYYY'), 1100, NULL, 20)

  INTO EMP VALUES (7900, 'JAMES',  'CLERK',     7698, TO_DATE('03-DEC-1981', 'DD-MON-YYYY'), 950,  NULL, 30)

  INTO EMP VALUES (7902, 'FORD',   'ANALYST',   7566, TO_DATE('03-DEC-1981', 'DD-MON-YYYY'), 3000, NULL, 20)

  INTO EMP VALUES (7934, 'MILLER', 'CLERK',     7782, TO_DATE('23-JAN-1982', 'DD-MON-YYYY'), 1300, NULL, 10)

SELECT * FROM DUAL;

Department Table Creation and Insertion Scripts in Oracle SQL

===========================================================

CREATE TABLE DEPT

       (DEPTNO NUMBER(2),

        DNAME VARCHAR2(14),

        LOC VARCHAR2(13) );

INSERT ALL

  INTO DEPT (DEPTNO, DNAME, LOC) VALUES (10, 'ACCOUNTING', 'NEW YORK')

  INTO DEPT (DEPTNO, DNAME, LOC) VALUES (20, 'RESEARCH',   'DALLAS')

  INTO DEPT (DEPTNO, DNAME, LOC) VALUES (30, 'SALES',      'CHICAGO')

  INTO DEPT (DEPTNO, DNAME, LOC) VALUES (40, 'OPERATIONS', 'BOSTON')

SELECT * FROM DUAL;

--4 rows inserted

select *from DEPT;

LOCATIONS  table creation and insertion script in ORacle SQL

=====================================================

CREATE TABLE LOCATIONS (

    LOCID      NUMBER(5) PRIMARY KEY,

    CITY       VARCHAR2(50),

    STATE      VARCHAR2(50),

    COUNTRY_ID NUMBER(5)

);

INSERT ALL 

    INTO LOCATIONS (LOCID, CITY, STATE, COUNTRY_ID) VALUES (1, 'BOSTON', 'BOSTON', 11)

    INTO LOCATIONS (LOCID, CITY, STATE, COUNTRY_ID) VALUES (2, 'DALLAS', 'DALLAS', 22)

    INTO LOCATIONS (LOCID, CITY, STATE, COUNTRY_ID) VALUES (3, 'CHICAGO', 'CHICAGO', 33)

SELECT * FROM DUAL;

Salary Grade Table Creation and Insertion Scripts in Oracle SQL

===========================================================

CREATE TABLE SALGRADE

        (GRADE NUMBER,

         LOSAL NUMBER,

         HISAL NUMBER);

 

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);