sql command 2 know current database

Answer Posted / pradeeshkumar

this will also work.

select global_name from global_name;

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is oracle an open source?

637


How to delete an existing row from a table in oracle?

643


Why oracle is used?

580


What happens if recursive calls get out of control?

548


What is dynamic proxy?

554






What is enter substitution variable in oracle?

573


How many data types are supported?

620


What will be the syntax to find current date and time in format "yyyy-mm-dd"?

569


Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2455


1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

1610


Explain the use of indexes option in exp command.

591


What is a read write transaction in oracle?

606


What is the meaning of recursive hints in oracle?

532


How to create lov dynamically at runtime & attach to text field?

664


What is a synonym? What are its various types?

622