Creation of tables in oracle

1. create table customer_master(custname varchar2(10),cin number(10)constraint con_pk primary key,accno number(10),opbal number(10),address varchar(10),phno number(10),opdate date);


2.create table card_master(cin number(10),cardno varchar2(16));
alter table card_master add constraint con_fk foreign key(cin) references customer_master5064(cin);
alter table card_master add constraint cad_pk primary key(cardno);

3) create table daily_transactions(cardno varchar2(16),trandate date,tranamt number(10),balance number(10),deposit number(10),withdraw number(10),txn_ref_no varchar2(20));
alter table daily_transactions add constraint txn_fk foreign key(cardno)references card_master5064(cardno);
alter table daily_transactions5064 add constraint txn_pk primary key(TXN_REF_NO);

insert into customer_master values('&custname',cust64.nextval,acc64.nextval,&opbal,'&address',&phno,'&opdate');

insert into card_master values(1111122222,cdno64.nextval);

No comments:

Post a Comment

Template Design by faris vio