psi_mmobile

Untitled

Oct 30th, 2025
151
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. select nvl(name_str.str_value,rts.name) name, nvl(desc_str.str_value, rts.description) description
  2. from ru_technical_status rts, gui_users gu, str name_str, str desc_str
  3. where rts.name_str_id = name_str.str_id(+)
  4. and rts.description_str_id = desc_str.str_id(+)
  5. and name_str.language = gu.language(+)
  6. and desc_str.language = gu.language(+)
  7. and gu.gui_user_id = :gui_user_id;
Advertisement
Add Comment
Please, Sign In to add comment