Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    20

    Unanswered: update in oracle 8i

    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

  2. #2
    Join Date
    Apr 2004
    Location
    USA
    Posts
    33
    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 );

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •