how do get database name at sql prompt?

Answer Posted / harikiran

select ora_database_name from dual

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we write insert statement in function in oracle?

844


What is an oracle database?

818


What is the relation of a user account and a schema in oracle?

864


How do we create privileges in oracle?

820


what is the scripts in data base?

1870


What is the parameter mode that can be passed to a procedure?

816


Name the three major set of files on disk that compose a database in Oracle?

865


When do you get a .pll extension in oracle?

935


What do you understand by database schema and what does it hold?

960


How to write text literals in oracle?

870


How do I find my oracle client driver version?

763


What privilege is needed for a user to create views in oracle?

819


nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

1978


Explain what are clusters?

868


How to get execution path reports on query statements?

777