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');
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)
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;