Home » SQL & PL/SQL » SQL & PL/SQL » query on update
query on update [message #241285] Tue, 29 May 2007 01:51 Go to next message
rolex.mp
Messages: 161
Registered: February 2007
Senior Member
i have two tables fnd_product_installations and ad_minipacks .

These two tables have a common column patch_level . there is no foreign key relationship and the deign of these tables cannot be changed .

patch_level column in ad_minipacks is super set of patch_level column in fnd_product_installtions

I wanna write a single update statement such that if i update any value in patch_level column of ad_minipacks it also updates patch_level column of fnd_product_installations
.

Is it possible with a single sql statement ?
Re: query on update [message #241288 is a reply to message #241285] Tue, 29 May 2007 01:57 Go to previous message
Michel Cadot
Messages: 64832
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
- Oracle version?
- Do you want it to be transparent to your current queries or do you want it only for new queries? (clue: trigger)
- Do you use these tables independently or are they always queried together? (clue: view)

Regards
Michel
Previous Topic: Question on Object
Next Topic: inserting large blob images
Goto Forum:
  


Current Time: Sat May 27 01:15:57 CDT 2017

Total time taken to generate the page: 0.08570 seconds