LOGANATHAN V

LOGANATHAN V

  • NA
  • 27
  • 20.6k

oracle-can i create like this but showing error while run

Mar 12 2011 8:51 AM

create table form1 
(empcid varchar2(25),empname varchar2(100),empid varchar2(25),empdgn varchar2(50),empdob date,empadd varchar2(200),empcom varchar2(15),empshare varchar2(10), empsdoj date, empedoj date,
constraint pkform1 primary key (empcid,empname,empid,empdgn));

create table deposit
(loanid varchar(25),openbal decimal(20,3),subcrp date, subamt decimal(20,3),totdep decimal(20,3),subamtint decimal(25,3),cumuint decimal(20,3),empcid varchar2(25),empname varchar2(100),empid varchar2(25),empdgn varchar2(25),
constraint pkedeposit primary key (loanid),
constraint fkform1 foreign key (empcid,empname,empid,empdgn) references form1);


create table sharecapital
(loanid varchar2(25),empedoj date,empshare varchar2(10),shareint decimal(20,3),loandt date,loandeduc varchar2(25),dividend decimal(25,3),sharetot decimal(25,3),empcid varchar2(25),empname varchar2(100),empid varchar2(25),empdgn varchar2(25),
constraint fkdep foreign key(loanid) references deposit(loanid)),
constraint fkscform1 foreign key (empcid,empname,empid,empdgn) references form1(empcid,empname,empid,empdgn));

showing error  when i execute sharecapital table "missing or invalid option"

i dunno how to correct it.

Answers (10)