You are here:
Oracle/oracle
Advertisement
Question
Respected Sir/Mam
I am using oracle10gXe but I am not able to see the my database name.
Is there any table which store the NAME OF all database
running on my computer
thanks in advance
Hi San,
How are you doing? If you want to see all the users in your database, then run the following command,
SELECT * FROM all_users;
Or if you want to know the database name and its connect string and when it is created and the OS the DB resides in etc etc...run the following sql
SELECT * FROM V$DATABASE;
Hope this helps
Related Articles
Oracle
Binosh Mullassery-Padman
Expertise
I can answer any questions on Oracle SQL and PL/SQL. The following are the topics I am an expert in Writing SQL using SQL 92 standards Oracle Advanced Groups Analytical Functions Hierarchial Queries Partition Objects and Collections Oracle XML Oracle regular Expressions Exception Handling Bulk Binding Dynamic SQL and PL/Sql Procedures Functions Packages Triggers Advanced Queueing Implicit and Explicit Cursors Oracle sql functions(CAST, CURSOR etc) Oracle SQL Tuning Oracle Execution Plans
Experience
10 Years as Developer and DBA
Organizations
Currently working with a Health Care industry
Education/Credentials
Masters in Computer Applications
©2012 About.com, a part of The New York Times Company. All rights reserved.