Hi all ,
Does Oracle support something similar,
update x
set col2 = y.col3
from
select y.col3 from x y
where col1 = 10.1
SQL Server support it from SQL Server 2000
Regards
George
Printable View
Hi all ,
Does Oracle support something similar,
update x
set col2 = y.col3
from
select y.col3 from x y
where col1 = 10.1
SQL Server support it from SQL Server 2000
Regards
George
Sure
Check this