SQL untuk mengetahui nama database oracle dari user
Untuk mengetahui database name, instance name, current user, dan host name dari sintak SQL Oracle, bisa dilakukan dengan cara berikut :
SQL:
select
user "CURRENT USER",
sys_context('userenv','instance_name') "INSTANCE NAME",
sys_context('userenv','db_name') "DB NAME",
sys_context('userenv', 'server_host') "HOST NAME"
from
dual;
Contoh output :
CURRENT USER INSTANCE NAME DB NAME HOST NAME
--------------------- ------------------------ ----------------- ---------------
APSQA orcl orcl hermanw-pc
1 rows selected
SQL:
select
user "CURRENT USER",
sys_context('userenv','instance_name') "INSTANCE NAME",
sys_context('userenv','db_name') "DB NAME",
sys_context('userenv', 'server_host') "HOST NAME"
from
dual;
Contoh output :
CURRENT USER INSTANCE NAME DB NAME HOST NAME
--------------------- ------------------------ ----------------- ---------------
APSQA orcl orcl hermanw-pc
1 rows selected
Komentar
good quality writing like yours these days. I truly appreciate
individuals like you! Take care!!
Stop by my homepage website []
you for supplying these details.
my site ::