OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » ora-00900 (10gR2.Windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ora-00900 [message #312626]

Wed, 09 April 2008 08:35

plshelp
Messages: 205
Registered: January 2007

Senior Member

Hi experts,

I am trying to add a column company to the existing table and this column will be a primary key and a foreign key, but not sure how to find out to which table its a foreign key for.
I have added the column as not null, added constraint for pk and the unique index. But I get 'ORA-00900:invalid SQL statement' when I execute the below query to add the foreign key constraint.

alter table cash_batch add (
constraint cmpdef_comp_cashbatch_fk foreign key (company)
references cmpdef(company));
);

Any suggestions?

Thank you

Report message to a moderator