Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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>