Mega Code Archive

 

Categories / Oracle PLSQL / System Packages

 

ORA_INSTANCE_NUM returns the current database instance number as a NUMBER datatype

SQL> SQL> DECLARE   2    instance NUMBER;   3  BEGIN   4      instance := ora_instance_num;   5      dbms_output.put_line('instance:'||instance);   6  END;   7  / instance:1 PL/SQL procedure successfully completed. SQL> SQL>