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
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: 65086
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)

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

Current Time: Tue Jul 25 06:23:51 CDT 2017

Total time taken to generate the page: 0.27093 seconds