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

Describe varray?

602


How to establish administrator authentication to the server?

569


What happens in oracle commit?

582


How to rollback the current transaction in oracle?

550


How to get a list of all user accounts in the database?

631






How to export your connection information to a file?

605


Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

1780


How do I escape a reserved word in oracle?

641


What is oracle analytical function?

540


definition of cluster and non-clustered index?

2486


How to retrieve the count of updated rows?

584


Will you be able to store pictures in the database?explain.

547


hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1577


What is a tns service name?

548


Explain coalesce function?

637