Query v$parameter for database name : V_Parameter « System Tables Views « Oracle PL / SQL






Query v$parameter for database name

  

SQL> select value a,sysdate c from v$parameter where name = 'db_name';

A
--------------------------------------------------------------------------------

C
---------
XE
26-OCT-09


SQL>
SQL>

   
    
  








Related examples in the same category

1.Query V$PARAMETER for current parameter settings.
2.Query parameter for
3.select Name, Value, IsDefault from V$PARAMETER
4.List database parameters