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> --
| 1. | Get current user name | ||
| 2. | Display current user | ||
| 3. | Get current user |