Home » SQL & PL/SQL » SQL & PL/SQL » how to give foreign key references from one user table to another user table
how to give foreign key references from one user table to another user table [message #226487] Sat, 24 March 2007 02:14 Go to next message
m.deep12
Messages: 1
Registered: March 2007
Location: BBSR
Junior Member

hi every body

i am new so sorry if write something wrong ..

i want to know, how can we give foreign key references to one user table to aonther user table
eg-:
suppose i create user king identified by king

.... and created table--- create table test(empno number primary key);
and another user scott idenitfied by tiger
... and created-- create table test1(empno number references king.test(empno))



Re: how to give foreign key references from one user table to another user table [message #226492 is a reply to message #226487] Sat, 24 March 2007 02:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Right but I think you got a faster and safer answer checking the SQL Reference manual, doesn't it?

Regards
Michel
Re: how to give foreign key references from one user table to another user table [message #226515 is a reply to message #226492] Sat, 24 March 2007 08:42 Go to previous message
orausern
Messages: 817
Registered: December 2005
Senior Member
also this link:
http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96590/adg05itg.htm#1489

Previous Topic: give privilages to users
Next Topic: Existing state of packages has been discarded...?
Goto Forum:
  


Current Time: Fri Dec 09 07:32:26 CST 2016

Total time taken to generate the page: 0.13994 seconds