Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Finding, Validating, and Describing Packages

SQL> SQL> COLUMN object_name FORMAT A10 SQL> SELECT  object_name   2  ,       object_type   3  ,       last_ddl_time   4  ,       timestamp   5  ,       status   6  FROM    user_objects   7  WHERE   object_name IN ('PIPELINED','PF'); no rows selected SQL>