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..

Report message to a moderator

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

Report message to a moderator

Previous Topic: Utl_File to export blob problem
Next Topic: Question on indexes
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 12 05:36:24 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.