Interview Answer

There’s an old story about the person who wished his computer were as easy to use as his telephone. That wish has come true, since I no longer know how to use my telephone. Bjarne Stroustrup

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.