sign in
 
   
 
 
 
   
  SQL Tutorial: (Based on M.G. University - MSc Computer Science)  
 
SQL Lab Practice - 1
 
   
  Answers:  
                        
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.