Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select nvl(name_str.str_value,rts.name) name, nvl(desc_str.str_value, rts.description) description
- from ru_technical_status rts, gui_users gu, str name_str, str desc_str
- where rts.name_str_id = name_str.str_id(+)
- and rts.description_str_id = desc_str.str_id(+)
- and name_str.language = gu.language(+)
- and desc_str.language = gu.language(+)
- and gu.gui_user_id = :gui_user_id;
Advertisement
Add Comment
Please, Sign In to add comment