| query on update [message #241285] |
Tue, 29 May 2007 01:51  |
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  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
