sql command 2 know current database

Answer Posted / madhu sekhar

You want to know the What is the Data Base version you are
using you can go like this

1) show version (In sql*Plus)
2) Select * from v$version;(In Toad or PL/SQL Developer)

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to drop an index in oracle?

609


How to loop through data rows in the implicit cursor?

541


How to add a new column to an existing table in oracle?

588


What are transaction isolation levels supported by oracle?

576


How to write a query with a right outer join in oracle?

613






How to load a large xml file?

584


Is oracle an open source?

637


How do we display rows from the table without duplicates?

550


Give syntax for SQL and ORACLE joins.

634


What is an oracle data file?

617


How can you use check constraints for self referential integrity?

522


how to handle exceptions in post production

950


Explain the difference between replace() and translate() functions in oracle?

581


What is parameterized cursor in oracle?

578


How translate command is different from replace?

548