deeejay

Oracle - Display Cerner Functions

Mar 31st, 2014
250
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT *
  2. FROM ALL_OBJECTS
  3. WHERE OBJECT_TYPE = 'FUNCTION'
  4. AND OWNER = 'V500'
  5. AND OBJECT_NAME LIKE 'RCR%';
  6.  
  7. SELECT TEXT
  8. FROM ALL_SOURCE
  9. WHERE OWNER = 'V500'
  10. AND TYPE = 'FUNCTION'
  11. AND NAME = 'RCRGETBALANCEDUE';
Advertisement