how do get database name at sql prompt?

Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

how do get database name at sql prompt?

Question Posted / jakki

3 Answers
7082 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how do get database name at sql prompt?..

Answer / mkumar.it

select name from v$database

Is This Answer Correct ?

14 Yes

0 No

how do get database name at sql prompt?..

Answer / harikiran

select ora_database_name from dual

Is This Answer Correct ?

3 Yes

1 No

how do get database name at sql prompt?..

Answer / jinesh

thnks

Is This Answer Correct ?

1 Yes

3 No

Post New Answer

More Oracle General Interview Questions

How to write text literals in oracle?

What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?

How to revoke create session privilege from a user in oracle?

How many types of table in Oracle?

0 Answers MCN Solutions,

What is an oracle database table?

How to open and close an explicit cursor in oracle?

what are the database links ?

Explain drop constraint oracle?

Define Normalization with example?

Whether Oracle satisfy more codd rules or db2 satisfy more codd rules? How meny of each can satisfy ? Please answer me. Advance thanks

What is recycle bin in Oracle?

0 Answers MCN Solutions,

can you write commit in triggers?

For more Oracle General Interview Questions Click Here

Categories

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)
Oracle Security (38)
Oracle Forms Reports (510)
Oracle Data Integrator (ODI) (120)
Oracle ETL (15)
Oracle RAC (93)
Oracle D2K (72)
Oracle AllOther (241)