The best programmers are not marginally better than merely good ones. They are an order-of-magnitude better, measured by whatever standard: conceptual creativity, speed, ingenuity of design, or problem-solving ability. Randall E. Stross

### create table and insert data into tables

April 12, 2016 7:26 pm

### 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);
```