hi
how to rum on 4 tables and update any field on them ?
in oracle 10g
thank's in advance
+1
A:
Your question doesn't really give enough information to give a good answer and besides it sounds like you already know the answer: construct a SP or func that will run your four queries for you, one for each table.
If that's not what you want, maybe this will help:
http://www.tek-tips.com/viewthread.cfm?qid=1422597&page=3
If any of this has been useful to you, you can help your stats by giving me a tick (shameless plug, I know) ;)
GenericMeatUnit
2010-02-04 09:36:58