web analytics
How to get the database name in Oracle? Options
codeling
Posted: Friday, September 9, 2016 9:27:17 AM

Rank:Advanced Member
Groups: Member
Joined: 12/11/2015
Posts: 758
Points: 3180

SQL> select sys_context('userenv','db_name') from dual;


SQL> select ora_database_name from dual;


SQL> select * from global_name;

Sponsor
Posted: Friday, September 9, 2016 9:27:17 AM
 
Users browsing this topic
Guest

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.


© 2017 Digcode.com. All rights reserved.