Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Determining Oracle Database Instance

Tags:

oracle

vinstance

Other than querying the v_$database and v_$instance tables (or the views v$instance, v$database) is there any other way to programtically retrieve (from PL/SQL) the database name of an oracle database?

like image 986
Jeff Avatar asked Dec 23 '22 12:12

Jeff

1 Answers

dbms_standard.database_name

like image 90
dpbradley Avatar answered Jan 29 '23 08:01

dpbradley
Sign in to Comment

Related questions

Alphanumeric sorting in Oracle
Oracle SQL: Re-use subquery for CASE WHEN without having to repeat subquery
SQL column name same as PL/SQL variable name - How can this be done in a select statement?
Compile PHP OCI8 extension under Alpinelinux
ORA-01821: date format not recognized error for ISO 8601 date with local time
return a varray from a function oracle
use bind variable with LIKE % operator
If NULL Then 0 Else Other Value
ORA-30372 fine grain access policy conflicts with materialized view
Oracle SQL - check missing indexes on SQL query
Oracle slow query
Compare BLOB against other BLOBs in Oracle database
regexp_replace for oracle to replace https not working
Trouble shooting ora-29471
Oracle 11 SQL : Split 1 row into x rows and insert a new column
How much of a resource hog is Oracle Enterprise Manager?
Is there a way to get types/names of an unknown db query without executing it?
How do I let my DBA pause and resume a stored procedure that is updating every row in a large table?
ASP Membership Odd Problem
How would you enforce DRY (Don't Repeat Yourself) in a SQL script?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!