Skip to content

Instantly share code, notes, and snippets.

@shaik2many

shaik2many/todo-oracle-opti

Created September 7, 2012 16:46
Show Gist options
  • Save shaik2many/3667687 to your computer and use it in GitHub Desktop.
Save shaik2many/3667687 to your computer and use it in GitHub Desktop.
Download ZIP
todo-oracle-opti
Raw
todo-oracle-opti
select t.*, a.*, b.* from tcom_user t,
(SELECT DISTINCT 'TRUE' is_proj_lib FROM vcom_security_useraction WHERE sso_id = 9005 AND action_group = 'PROJ_LIB') a,
(SELECT DISTINCT 'TRUE' is_proj_edit FROM vcom_security_useraction WHERE sso_id = 9005 AND action_group = 'PROJ_EDIT') b
where sso_id = 9005
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment