advanced code snippet search

Posted By

geekzspot on 01/12/13


Tagged


Versions (?)

Oracle List my Packages

 / Published in: SQL
 

List all Package Names owned by me

Expand | Embed | Plain Text 
  1. SELECT OBJECT_NAME AS PACKAGE_NAME 
  2.   FROM all_objects 
  3.  WHERE owner = USER 
  4.    AND object_type = 'PACKAGE' 
  5.  ORDER BY object_name
  6. ;

Report this snippet  

You need to login to post a comment.