SQL> select dbms_metadata.get_ddl('PACKAGE','MVIEW_REFRESH_API','BATCHP') metad from dual;

  CREATE OR REPLACE PACKAGE "BATCHP"."MVIEW_REFRESH_API"
AS

    /**

ind> select table_name||' Is the '  ||COMMENTS
  2  from dict
  3  where TABLE_NAME like '%SOURCE';

TABLE_NAME||'ISTHE'||COMMENTS
----------------------------------------------------------------------------------------------------
USER_SOURCE Is the Source of stored objects accessible to the user
ALL_SOURCE Is the Current source on stored objects that user is allowed to create
DBA_SOURCE Is the Source of all stored objects in the database
--------------------------------------

6 rows selected.