title: How to get a list with description of all dba packages
body: <p>I need an overview in my application of all packages you can use in an sql or pl/sql statement from the database.
  I need the package name and procedures/functions with there description.</p>
  
  <p>So for example:</p>
  
  <p>dbms_output: Package to give some output</p>
  
  <p>dbms_output.put_line: procedure to return some output to serveroutput</p>
  
  <p>Can this be done using a normal select ?</p>
  
  <p>I tried already the following which gives me data but not a description and not the procedures and or functions of the packages:</p>
  
  <pre><code>SELECT DISTINCT Owner, Object_Type, Object_Name FROM DBA_Objects_AE
       WHERE Owner IN (
         'SYS', 'OUTLN', 'SYSTEM', 'CTXSYS', 'DBSNMP',
         'LOGSTDBY_ADMINISTRATOR', 'ORDSYS',
         'ORDPLUGINS', 'OEM_MONITOR', 'WKSYS', 'WKPROXY',
         'WK_TEST', 'WKUSER', 'MDSYS', 'LBACSYS', 'DMSYS',
         'WMSYS', 'OLAPDBA', 'OLAPSVR', 'OLAP_USER',
         'OLAPSYS', 'EXFSYS', 'SYSMAN', 'MDDATA',
         'SI_INFORMTN_SCHEMA', 'XDB', 'ODM')
       AND Object_Type IN ('PACKAGE', 'TYPE')
       ORDER BY Owner, Object_Type, Object_Name;
  
  
  select *
  from all_objects
  where object_type = 'PACKAGE';
  </code></pre>