Seminar Topics & Project Ideas On Computer Science Electronics Electrical Mechanical Engineering Civil MBA Medicine Nursing Science Physics Mathematics Chemistry ppt pdf doc presentation downloads and Abstract

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;