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


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?

Re: Foreignkey [message #238496 is a reply to message #238491] Fri, 18 May 2007 06:06 Go to previous message
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: Sun Oct 23 13:13:01 CDT 2016

Total time taken to generate the page: 0.12232 seconds