ORA_IS_CREATING_NESTED_TABLE returns a true or false value as a BOOLEAN datatype when you create a table with a nested table. : ORA « System Packages « Oracle PL / SQL
ORA_IS_CREATING_NESTED_TABLE returns a true or false value as a BOOLEAN datatype when you create a table with a nested table.
SQL>
SQL> BEGIN
2 IF ora_sysevent = 'CREATE' AND ora_dict_obj_type = 'TABLE' AND ora_is_creating_nested_table THEN
3 dbms_output.put_line(ora_dict_obj_name);
4 END IF;
5 END;
6 /
PL/SQL procedure successfully completed.
SQL>
SQL>