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






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

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