Interview Answer

If McDonalds were run like a software company, one out of every hundred Big Macs would give you food poisoning, and the response would be, ‘We’re sorry, here’s a coupon for two more.’ “ Mark Minasi

create table and insert data into tables

January 1, 1970 12:00 am

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.