To get the basic database information such as the database name, dbid, creation time, archiving information etc query V$DATABASE view.
SQL> Select * From V$DATABASE;
To view the oracle version query V$VERSION view.
SQL> Select * From V$VERSION;
Wednesday, July 1, 2009
Subscribe to:
Post Comments (Atom)
1 comment:
Thanks for sharing this query to get the deatils of database like name, id, creation time and its version. I have also other queries too that you have posted in other articles, I will implement this one also. Keep posting more in future also.
Post a Comment