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

Differentiate between translate and replace?

829


How to assign a tablespace to a users in oracle?

804


How many types of synonyms in Oracle?

844


Explain oracle data types with examples?

780


What are the different types of failures that occur in Oracle database?

844


hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2161


What is an oracle data file?

854


Describe varray?

853


What is system global area (sga) in oracle?

791


How to view the tablespaces in the current database?

768


Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1740


Can a formula column referred to columns in higher group ?

2281


What is a procedure in oracle?

804


Explain integrity constraints?

889


What is the difference between translate and replace?

829