how to write sub queries ..under this condition

oracle_student · #1 (**permalink**) 12-02-03, 10:16

Hi,

i want to update my primary key.in my table....

but it is used as foreign keys....

i want to update using single query..it is possible for me to update it..

pls give me idea for updating using query....

reply me..

thanx....

sathyaram_s · #2 (**permalink**) 12-02-03, 16:36

If you are on Version 8, have a look at the MERGE Statement and see if it helps ...

It will be highly appreciated if you can post your findings here

Cheers
Sathyaram

Quote:

Originally posted by oracle_student
Hi,

i want to update my primary key.in my table....

but it is used as foreign keys....

i want to update using single query..it is possible for me to update it..

pls give me idea for updating using query....

reply me..

thanx....

Internet Services

Web Development

Digital Marketing

Consumer Tech