Mega Code Archive

 

Categories / Oracle PLSQL / System Packages

 

ORA_IS_CREATING_NESTED_TABLE returns a true or false value as a BOOLEAN datatype when you create a table with a nested tab

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>