SQL>
SQL> COLUMN object_name FORMAT a25
SQL> COLUMN created FORMAT a20
SQL> COLUMN updated FORMAT a20
SQL> SELECT object_name, object_type,
2 TO_CHAR(created, 'MM/DD/YY HH24:MI:SS') created,
3 TO_CHAR(last_ddl_time, 'MM/DD/YY HH24:MI:SS') updated
4 FROM dba_objects
5 WHERE object_type IN ('PACKAGE','PACKAGE BODY', 'PROCEDURE',
6 'FUNCTION', 'TRIGGER')
7 AND OWNER = 'PLSQL_USER'
8 and rownum < 50
9 ORDER BY object_name;
no rows selected
SQL>