Advertisement
brianleepasc

Sample PL/SQL

Jun 8th, 2016
301
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.25 KB | None | 0 0
  1. SELECT USERS.USERID, USERS.PASSWORD, USERPROFILE.*
  2. FROM USERPROFILE INNER JOIN USERS ON USERS.USER_KEY = USERPROFILE.USER_KEY
  3. WHERE 1=1
  4. AND SECTION         ='WORKLIST'
  5. AND VALUE           ='D3300'
  6. AND ENTRY           ='FAVORITE_PAGE'
  7. AND USERS.USERID    ='mat_suong'
  8. ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement