Query parameter for : V_Parameter « System Tables Views « Oracle PL / SQL






Query parameter for

  


SQL> select name, value from v$parameter where name='user_dump_dest';



NAME
------------------------------------------------------
VALUE
------------------------------------------------------
user_dump_dest
C:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP

1 row selected.

SQL>
SQL>

   
    
  








Related examples in the same category

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