SQL> SET PAGES 1000
SQL> COLUMN object_name FORMAT a30;
SQL> COLUMN object_type FORMAT a30;
SQL> SELECT object_name,object_type,status FROM user_objects WHERE object_name='FUNCTION_SAMPLE';
OBJECT_NAME OBJECT_TYPE STATUS
------------------------------ ------------------------------ --------------
FUNCTION_SAMPLE FUNCTION VALID
SQL>
|