oracle_create_table1
 

Script:;

--DROP TABLE S1;
CREATE TABLE S1
(
eid NUMBER(2) NOT NULL,
fname VARCHAR(20),
lname VARCHAR(30),
address VARCHAR(100),
CONSTRAINT pk_S1 PRIMARY KEY (eid)
);
INSERT INTO S1
VALUES (10, 'Anita','Das', 'Address 1');
INSERT INTO S1
VALUES (11, 'Frank','Delon', 'Address 2');
INSERT INTO S1
VALUES (12, 'Juno','Rastogi', 'Address 3');
INSERT INTO S1
VALUES (13, 'Sunil','Pandey', 'Address 4');

 

Confirming with SQL-Developer ( if already loaded Refresh the schema/user)
You may use SQL*PLUS or SQL-Developer to insert the data

To create a report with a descent format, you may use the following script.

SQL> column fname format a10
column lname format a15
column address format a15
select * from s1;