Monday, August 17, 2020

[Oracle][Resolved] Oracle get current db name

In this example, Suppose the database we are using is named "QASYS" but I don't know the name, we can use this sql to check:

sql:

SELECT * FROM global_name;


Result

QASYS.REGRESS.RDBMS.DEV.US.ORCALE.COM


Reference:

https://stackoverflow.com/questions/6288122/checking-oracle-sid-and-database-name

No comments :

Post a Comment