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 generate query output in html format?

799


How do we create privileges in oracle?

838


How do I manually uninstall oracle client?

809


How to calculate date and time differences in oracle?

818


What suggestions do you have to reduce the network traffic?

759


What is the fastest query method to fetch data from the table?

1144


What is a read only transaction in oracle?

841


How to create an oracle testing table?

841


What are the limitations of check constraint?

819


What is a system tablespace?

859


What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4262


How many types of synonyms in Oracle?

872


How would you best determine why your MVIEW couldnt FAST REFRESH?

1671


What is the difference between a primary key & a unique key?

869


What are the original export and import utilities?

803