how do get database name at sql prompt?

Answer Posted / mkumar.it

select name from v$database

Is This Answer Correct ?    14 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a database schema in oracle?

619


How much memory your 10g xe server is using?

578


How to speed up webrick?

591


How to use "for" statements in oracle?

588


Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

1858






How to select some rows from a table in oracle?

596


I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

1696


How to use an explicit cursor without open statements?

612


How to use "startup" command to start default instance?

542


Explain drop constraint oracle?

589


How to convert characters to numbers in oracle?

592


What are the major difference between truncate and delete?

515


What is difference between cartesian join and cross join?

582


How to rollback the current transaction in oracle?

538


Explain the use of owner option in exp command.

567