Oracle query Database name

In this tutorial, How do I use the Oracle query Database name? Using “v$parameter” for the database name.

Connect SYS as SYSDBA

[huupv@localhost ~]$ sudo su - oracle
[oracle@localhost ~]$ sqlplus "/as sysdba"

Oracle query Database name

SQL> SELECT name, value from v$parameter WHERE name = 'db_name' order by name;

The screen output terminal

NAME                         VALUE
--------------------------- -----------
db_name                  DRDB1

Conclusion

Thought the article, You can use “Oracle query Database name” as above . I hope will this your helpful.

,

About HuuPV

My name is Huu. I love technology and especially Devops Skill such as Docker, vagrant, git so forth. I likes open-sources. so I created DevopsRoles.com site to share the knowledge that I have learned. My Job: IT system administrator. Hobbies: summoners war game, gossip.
View all posts by HuuPV →

Leave a Reply

Your email address will not be published. Required fields are marked *

Comment moderation is enabled. Your comment may take some time to appear.

This site uses Akismet to reduce spam. Learn how your comment data is processed.