How to check the Oracle database version

858277

Hi,

How can i check, what type of database am using and which version?

Can anyone help me to know?

Centinul

You can try:

SELECT * FROM V$VERSION

or

SELECT version FROM V$INSTANCE

or

BEGIN DBMS_OUTPUT.PUT_LINE(DBMS_DB_VERSION.VERSION || '.' || DBMS_DB_VERSION.RELEASE); END;

Centinul

You can try:

SELECT * FROM V$VERSION

or

SELECT version FROM V$INSTANCE

or

BEGIN DBMS_OUTPUT.PUT_LINE(DBMS_DB_VERSION.VERSION || '.' || DBMS_DB_VERSION.RELEASE); END;

onkar.nath

I am not sure what exactly you mean by "what type of database am using " but you can try this:

select from v$version;*

This will give you detailed version number of the database components. You can also use

select from PRODUCT_COMPONENT_VERSION;*

to get various components of the DB with their version.

Onkar

858277

Thanks