Guest User

Untitled

a guest
Oct 18th, 2017
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.57 KB | None | 0 0
  1. -- if you have DBA grants
  2. select s.text
  3. from DBA_SOURCE s -- (DBA_SOURCE describes the text source of all stored objects in the database)
  4. where 1 = 1
  5. and s.owner = 'APPS'
  6. and s.type = 'PACKAGE BODY'
  7. and s.name = 'MDB_LOG_ENVIA_CARGAS_GKO_PKG'
  8. order by s.line
  9. ;
  10.  
  11. -- if you don't have DBA grants
  12. select s.text
  13. from ALL_SOURCE s -- (ALL_SOURCE describes the text source of the stored objects accessible to the current user.)
  14. where 1 = 1
  15. and s.owner = 'APPS'
  16. and s.type = 'PACKAGE BODY'
  17. and s.name = 'MDB_LOG_ENVIA_CARGAS_GKO_PKG'
  18. order by s.line
  19. ;
Add Comment
Please, Sign In to add comment