	AllExperts > Oracle
	Search

About 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

You are here: Experts > Computing/Technology > Oracle > Oracle > oracle

Oracle - oracle

Expert: Binosh Mullassery-Padman - 11/5/2009

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

Answer
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

Add to this Answer Ask a Question