Use current user name in where clause
SQL>
SQL> select object_name, object_type
2 from all_objects
3 where owner = user
4 /
OBJECT_NAME OBJECT_TYPE
------------------------------ --------------------
MYTABLE_SESSION TABLE
DONTCOUNTSP FUNCTION
DO_COMMIT PROCEDURE
DONE TABLE
MY_TO_DATE FUNCTION
EXITFUNC
FACTORIAL
EMP_CHANGE_S PROCEDURE
LOG_SHUTDOWN TRIGGER
ADDRESS TYPE
LOG_STARTUP TRIGGER
ADDRESS TYPE BODY
EMP_PUBLIC_DATA VIEW
EMP_NAME_CHANGE TRIGGER
EMP_DEPT_PROCS PACKAGE
EMP_DEPT_PROCS PACKAGE BODY
DEBUG
ERASE PROCEDURE
GETEMPBLDGNAME FUNCTION
ASSIGNEMPTOBLDG PROCEDURE
DEBUG PACKAGE
ADD_MON FUNCTION
RAISE
ASSERT PROCEDURE
MAKE_MYTABLE
WRITE_NAME
HELLO
EMP_CHG TYPE
EMP_CHANGES TABLE
SYS_C005784 INDEX
SYS_LOB0000016238C00034$$ LOB
AQ$_EMP_CHANGES_S TABLE
SYS_C005787 INDEX
AQ$_EMP_CHANGES_V EVALUATION CONTEXT
AQ$_EMP_CHANGES_T TABLE
AQ$EMP_CHANGES_S VIEW
AQ$_EMP_CHANGES_N SEQUENCE
SYS_IOT_TOP_16247 INDEX
AQ$_EMP_CHANGES_H TABLE
EMPLOYEES_LIST TYPE
EMPLOYEE_TYPE
VIEW_T VIEW
STATE_PACKAGE PACKAGE
SHAPE TYPE
DEPT_EMP_VIEW VIEW
IO_BIFER_DEPT_EMP_VIEW TRIGGER
DEPARTMENT_10 VIEW
COMPILE_SCHEMA_TMP_PK INDEX
GET_NEXT_OBJECT_TO_COMPILE PROCEDURE
COMPILE_SCHEMA
COMPILE_SCHEMA_TMP TABLE
PRINT_TABLE PROCEDURE
SHOW_SPACE
DEBUG_TIMER
VC2TAB TYPE
P PROCEDURE
PEOPLE PACKAGE
PEOPLE PACKAGE BODY
TEMP_EMP TABLE
P_ADD_PROD PROCEDURE
P_ADD_EMPS
P_ADD_ORDERS
MEASURE_USAGE
SYS_IOT_TOP_15816 INDEX
UPPER_ENAME TABLE
SHOW_IOT_SPACE PROCEDURE
SYS_IOT_TOP_16249 INDEX
SYS_IOT_OVER_16251 TABLE
AQ$_EMP_CHANGES_G
SYS_IOT_TOP_16251 INDEX
AQ$_EMP_CHANGES_I TABLE
SYS_IOT_TOP_16254 INDEX
AQ$_EMP_CHANGES_E QUEUE
AQ$_EMP_CHANGES_F VIEW
AQ$EMP_CHANGES
EMP_DEPT_CHANGES_R RULE SET
EMP_DEPT_CHANGES_N
AQ$EMP_CHANGES_R VIEW
EMP_DEPT_CHANGES QUEUE
DEPT_AND_EMP TABLE
FILE_DUMP PROCEDURE
EMP_REG TABLE
EMP_TYPE TYPE
EMP_TAB_TYPE
EMPS_NT TABLE
SYS_C005826 INDEX
SYS_C005827
SUPER_TYPE TYPE
SESS_EVENT TABLE
NEW_PERSON TYPE
PERSON
NEW_PERSON TYPE BODY
LOGON_TRIGGER TRIGGER
VIRTUAL_TABLE_TYPE TYPE
ROWTYPE
ELEMENTTYPE
RESULTTYPE
COMPANY_LISTING PROCEDURE
PIVOT FUNCTION
VIRTUAL_TABLE
REMOVE_CONSTANTS
SQL_AREA_TMP TABLE
102 rows selected.
SQL>
SQL>
SQL> --
Related examples in the same category