12-01-2012, 01:18 PM
oracle program
[attachment=16022]
SQL> create table deposit(actno varchar(5),cname varchar(18),bname varchar(18),amount number(8,2),a
adate date);
Table created.
SQL> create table branch(bname varchar(18),city varchar(18));
Table created.
SQL> create table customers(cname varchar(19),city varchar(18));
Table created.
SQL> create table borrow(loanno varchar(5),cname varchar(18),bname varchar(18),amount number(8,2));
Table created.
SQL> insert into deposit values('100','Anil','VRCE',1000.00,'1-mar-95');
1 row created.
SQL> insert into deposit values('101','Sunil','AJNI',5000.00,'4-jan-96');
1 row created.
SQL> insert into deposit values('102','Mehul','KAROLBAGH','3500.00','17-nov-95');
1 row created.
SQL> insert into deposit values('104','Madhuri','CHANDNI',1200.00,'17=dec-97');
1 row created.
SQL> insert into deposit values('105','Pramod','chandnichowk','3000.00','27-mar-96');
1 row created.
SQL> insert into deposit values('106','Sandip','andheri',2000.00,'23-mar-98');
1 row created.
SQL> insert into deposit values('107','shivam','rohini',4000.00,'23-feb-95');
1 row created.
SQL> select * from deposit;