SQL statements to create EMP DEPT and GRADE tables

This zipped text file contains three SQL blocks which should create and populate the EMP, DEPT and GRADE tables in SQL compliant databases

It contains three blocks that look like this

// create table SQL
create table emp (
empno int,
… etc.
);
// Lines to insert tuples into the table created above
insert into emp values (405,”MARCH”,”ADMIN”,938,”13/06/1997″,18000,null,2);
insert into emp values (535,”BYRNE”,”SALES”,734,”15/08/1997″,26000,300,3);
etc..

Leave a Reply

Your email address will not be published.