Interview Answer

Thatís the thing about people who think they hate computers. What they really hate is lousy programmers. Larry Niven

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.