Click here to Skip to main content
15,885,278 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
SQL
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.
Posted
Updated 15-Mar-11 13:03pm
v3
Comments
Sandeep Mewara 12-Mar-11 8:16am    
What error?
laurancelove 12-Mar-11 9:01am    
ORA-00922: missing or invalid option

It's been long time touched oracle

So here you go

ORA-00922: missing or invalid option[^]
 
Share this answer
 
references deposit(loanid)) i have made 2 brackets that is my mistake.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900