How do we restrict the insert/ updates on the foreign column in a table if that table is in different instance that the table with Primary Key. Say for Example Emp and Dept Table. We have deptno in both tables and Deptno in Emp table is the Primary Key and other is foreign Key. How do we control what values we insert in Dept table if both the tables are not in the same instance.

Questions by sbagai2001   answers by sbagai2001

Showing Answers 1 - 3 of 3 Answers

Sridhar

  • Jun 29th, 2006
 

Please reframe the question properly.  Question framing is not proper

  Was this answer useful?  Yes

Prakash Pagam

  • Jul 24th, 2006
 

We can do using databasename.tablename

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions