SQL> create table client_master(client_no char(6) primary key,
2 name char(30) not null,city char(20) not null, pincode integer not null,
3 bal_due integer not null);
Table created.
SQL> insert into client_master values('&client_no','&name','&city',&pincode,&bal_due);
Enter value for client_no: C00001
Enter value for name: SMITHA JAIN
Enter value for city: Mumbai
Enter value for pincode: 400054
Enter value for bal_due: 15000
old 1: insert into client_master values('&client_no','&name','&city',&pincode,&bal_due)
new 1: insert into client_master values('C00001','SMITHA JAIN','Mumbai',400054,15000)
1 row created.
SQL> /
Enter value for client_no: C00002
Enter value for name: VANDANA RAO
Enter value for city: Chennai
Enter value for pincode: 780001
Enter value for bal_due: 0
old 1: insert into client_master values('&client_no','&name','&city',&pincode,&bal_due)
new 1: insert into client_master values('C00002','VANDANA RAO','Chennai',780001,0)
1 row created.
SQL> /
Enter value for client_no: C00003
Enter value for name: PREM PUJARI
Enter value for city: Mumbai
Enter value for pincode: 400057
Enter value for bal_due: 5000
old 1: insert into client_master values('&client_no','&name','&city',&pincode,&bal_due)
new 1: insert into client_master values('C00003','PREM PUJARI','Mumbai',400057,5000)
1 row created.
SQL> /
Enter value for client_no: C00004
Enter value for name: BASU NATH
Enter value for city: Mumbai
Enter value for pincode: 400056
Enter value for bal_due: 0
old 1: insert into client_master values('&client_no','&name','&city',&pincode,&bal_due)
new 1: insert into client_master values('C00004','BASU NATH','Mumbai',400056,0)
1 row created.
SQL> /
Enter value for client_no: C00005
Enter value for name: RAVI SHANKAR
Enter value for city: Delhi
Enter value for pincode: 100001
Enter value for bal_due: 2000
old 1: insert into client_master values('&client_no','&name','&city',&pincode,&bal_due)
new 1: insert into client_master values('C00005','RAVI SHANKAR','Delhi',100001,2000)
1 row created.
SQL> /
Enter value for client_no: C00006
Enter value for name: ROOPA
Enter value for city: Mumbai
Enter value for pincode: 400050
Enter value for bal_due: 0
old 1: insert into client_master values('&client_no','&name','&city',&pincode,&bal_due)
new 1: insert into client_master values('C00006','ROOPA','Mumbai',400050,0)
1 row created.
SQL> select * from client_master;
CLIENT NAME CITY PINCODE BAL_DUE
------ ------------------------------ -------------------- ---------- ----------
C00001 SMITHA JAIN Mumbai 400054 15000
C00002 VANDANA RAO Chennai 780001 0
C00003 PREM PUJARI Mumbai 400057 5000
C00004 BASU NATH Mumbai 400056 0
C00005 RAVI SHANKAR Delhi 100001 2000
C00006 ROOPA Mumbai 400050 0
6 rows selected.
|