Saii
bless you!!!!
it is working fine
thanks you so much for your help!
Cimetta
cimetta
Last Activity: Oct 9 '07, 02:31 PM
Joined: Sep 26 '07
Location:
-
Sorry everyone
I should have been a bit more precise:
what I need to do is update few tables at the same time and all passing the same value so I would like to know if with oracle 9i
it is possible to assign a value to a variable then pass this value to the fileds when running my update statement
so:
presuming that this will work I would like to do something like that:
...Leave a comment:
-
Updating multiple table in one command passing a value through a variables
Does anyone knows how could i do make haapen this in oracle 9i
please help!
*************** *************** ***********
var a
var b
var a = ' 4844'
var b = ' 4851'
update sevt
set resid = 'a'
where resid = 'b'
and
update evdub_ex
set resid = ' 4844'
where resid = ' 4851'
No activity results to display
Leave a comment: