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

What is difference between cartesian join and cross join?

814


Can you drop an index associated with a unique or primary key constraint?

787


How do we display rows from the table without duplicates?

737


How to assign data of the deleted row to variables?

817


Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

1992


How to list all tables in your schema?

798


Please explain joins in oracle?

813


How do I know if oracle is installed on windows?

675


How to rename an index in oracle?

827


Explain the use of grant option in exp command.

775


How to save query output to a local file?

798


How to use "in" parameter properly?

819


Which dictionary tables and/or views would you look at to diagnose a locking issue?

1688


Explain the use of record option in exp command.

762


Explain oracle’s system global area (sga).

870