Mega Code Archive

 

Categories / Oracle PLSQL / System Packages

 

ORA_DICT_OBJ_NAME returns an object name as a VARCHAR2 datatype

SQL> SQL> DECLARE   2    database VARCHAR2(50);   3  BEGIN   4      database := ORA_DICT_OBJ_NAME;   5      dbms_output.put_line('database:'||database);   6  END;   7  / database: PL/SQL procedure successfully completed. SQL> SQL>