/* set the line width of display to 100 characters per line*/ 
set lin 100; 

/* create a prof table */ 
create table PROF (pid char(20), name char(20), dept char(20), rank char(20), sal integer, primary key(pid));

/* insert values into the table */ 
insert into PROF values('p1', 'adam', 'cs', 'asst', 6000);
insert into PROF values('p2', 'bob', 'ee', 'asso', 8000);
insert into PROF values('p3', 'calvin', 'cs', 'full', 10000);
insert into PROF values('p4', 'dorothy', 'ee', 'asst', 5000);
insert into PROF values('p5', 'emily', 'ee', 'asso', 8000);
insert into PROF values('p6', 'frank', 'cs', 'full', 9000); 

/* display the content of the table */ 
select * from PROF; 

/* see what tables you have created so far */ 
select * from user_objects where object_type = 'TABLE'; 

/* remove table prof */ 
drop table PROF;