Interview Answer

Computer science education cannot make anybody an expert programmer any more than studying brushes and pigment can make somebody an expert painter. Eric S. Raymond

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.