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

LOGANATHAN V

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.

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suthish Nair15y ago
Accepted answer
try...

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)
);
Sam Hobbs15y ago
Yes it is frustrating when developers only want a complete answer with sample code. It happens a lot. Of course one of the recent examples was that Lennie guy but that is not the only one. Another recent one is the question about dynamically removing and addig tab pages in a tab control.
Suthish Nair15y ago
Why coders visiting forums, for faster solutions only. They not trying to learn and solve the errors. He simply says to your reply "again same problem". So try to sort out why the error coming, how to solve. Get help from us to resolve it, not ready made codes.
Vulpes15y ago
Thanks Suthish & Loganathan.

I just wanted confirmation that I'm not going mad ;)
LOGANATHAN V15y ago
actually i made brackets extra in loanid)) just notice it.you both were mentioned correct answer i didn't notice properly friend it's my mistaken only
Suthish Nair15y ago
Actually, this is a duplicate post....
Suthish Nair15y ago
I don't know friend, You pointed the right way. He was looking for a ready made answer. He posted the same question for couple of times now. Thats y i taut of posting the code. I don't mind if he accept your thread as answer again.
Vulpes15y ago
Just for the sake of my sanity here can anyone explain why my suggestion didn't work but Suthish's did?

For the life of me, I can't see any difference between the two :-/
LOGANATHAN V15y ago
no use of remove ) friend. again same problem
Vulpes15y ago
It looks to me as though this bit:

constraint fkdep foreign key(loanid) references deposit(loanid)),

has two many brackets at the end and should be:

constraint fkdep foreign key(loanid) references deposit(loanid),