Hi could someone help me to transform this sql statement that works on sybase, to work on oracle 8i:
update user_lvl, prg_lvl
set user_lvl.menu_module = 2,
user_lvl.menu_order = 6,
user_lvl.menu_level = 4
where prg_lvl.menu_tag = 'Menu=w_app_status;' and
user_lvl.menu_module = prg_lvl.menu_module and
user_lvl.menu_order = prg_lvl.menu_order and
user_lvl.menu_level = prg_lvl.menu_level and
user_lvl.menu_lang = prg_lvl.menu_lang and
user_lvl.menu_prog = prg_lvl.menu_prog ;
Thanks in advance

update user_lvl
set menu_module = 2,
menu_order = 6,
menu_level = 4
where exists(
select 1 from prg_lvl where prg_lvl.menu_tag = 'Menu=w_app_status;' and
user_lvl.menu_module = prg_lvl.menu_module and
user_lvl.menu_order = prg_lvl.menu_order and
user_lvl.menu_level = prg_lvl.menu_level and
user_lvl.menu_lang = prg_lvl.menu_lang and
user_lvl.menu_prog = prg_lvl.menu_prog );