Interview Answer

If debugging is the process of removing bugs, then programming must be the process of putting them in. Edsger W. Dijkstra

create table and insert data into tables

April 12, 2016 7:26 pm

Comments



create table and insert data into tables


Create table create the table with given format. The primary key constraint uniquely identifies each record in a database table.


Solution

   					 
												create table employee (
												  id     number  primary key,
												  empname   varchar2(50),
												  empage  number
												);

												-- The following sql query inserts the data into table.

												INSERT INTO employee (id,empname,empage) VALUES (empid.nextval,'Selva',11);
												INSERT INTO employee (id,empname,empage) VALUES (empid.nextval,'James',22);
												INSERT INTO employee (id,empname,empage) VALUES (empid.nextval,'Josephine',55);
												INSERT INTO employee (id,empname,empage) VALUES (empid.nextval,'Art',77);
												INSERT INTO employee (id,empname,empage) VALUES (empid.nextval,'Lenna',35);
												INSERT INTO employee (id,empname,empage) VALUES (empid.nextval,'Donette',67);
																    

Comments



Please login to add comments.