Home » SQL & PL/SQL » SQL & PL/SQL » Foreignkey
Foreignkey [message #238491] Fri, 18 May 2007 05:59 Go to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member

Hi,

I have a dept table and emp table.emp table is deptno column is foreign key.dept table deptno column is primary key.i want to reorganise(insert new records or delete old records)in dept (parent) table .What can i do?Any ways are there?

Arun..
Re: Foreignkey [message #238496 is a reply to message #238491] Fri, 18 May 2007 06:06 Go to previous message
saibal
Messages: 111
Registered: March 2007
Location: India
Senior Member
Do it by disabling the constraints or using CASCADE
Previous Topic: Utl_File to export blob problem
Next Topic: Question on indexes
Goto Forum:
  


Current Time: Fri Dec 02 14:24:03 CST 2016

Total time taken to generate the page: 0.24447 seconds