select Database_Status from V$INSTANCE : V_instance « System Tables Views « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Tables Views
  3. V_instance

select Database_Status from V$INSTANCE

   

SQL> select Database_Status from V$INSTANCE;
                                                              

DATABASE_STATUS
-----------------
ACTIVE








Related examples in the same category

1.select Active_State from V$INSTANCE
2.V$INSTANCE view provides one row of statistics for each Oracle instance running against the database
3.v$instance.instance_name