OraQA

Oracle Question and Answer


Latest Comments

  • Laurent Schneider:
    if you like a Base64 format, maybe this… select utl_raw.cast_to_varchar 2(...

  • hsafra:
    You need to give more specs for the question: What letter are acceptable? What letters aren’t? Do you...

  • ragunathansd:
    I am not inserting sequence numbers from database. I need to populate the data in a grid. If a user...

  • gamyers:
    “redo log file gets full” That is the nature of a redo log file. It gets full, switched and...

Comments RSS feed


  • Do you have a solution to a problem? Do you have an unanswered question? Login and share it with the Oracle community. More...

Oracle News


Entries RSS feed

Comments RSS feed
« How do I see who is currently connected?

How to set a table in read-only mode ? »

How to see the database version?

January 9th, 2006 By Radoslav Rusinov

To view components and their versions, loaded into the database:

SELECT comp_name, status, version FROM dba_registry;

To view version numbers of core library components, including the database:

SELECT banner FROM v$version;

To display options that are installed (the value column is ‘FALSE’ if the option is not installed)

SELECT parameter, value FROM v$option;

Filed under Concepts, SQL. Follow any responses to this entry through this RSS 2.0 feed.  

3 Responses to “How to see the database version?”

  1. Robertc Says:
    January 20th, 2006 at 12:40 pm

    Connected to:
    Oracle Database 10g Express Edition Release 10.2.0.1.0 - Beta

    SQL> SELECT comp_name, status, version FROM dba_registry;
    SELECT comp_name, status, version FROM dba_registry
    *
    ERROR at line 1:
    ORA-00942: table or view does not exist

  2. Robertc Says:
    January 20th, 2006 at 12:43 pm

    ^^^
    must log in as dba to SELECT on “dba_registry”

  3. Eddie Awad Says:
    February 6th, 2006 at 10:47 am

    Another way:

    HR@XE> select product, version
  2  from product_component_version;

PRODUCT                        VERSION
------------------------------ ----------
NLSRTL                         10.2.0.1.0
Oracle Database 10g Express Ed 10.2.0.1.0
ition

PL/SQL                         10.2.0.1.0
TNS for 32-bit Windows:        10.2.0.1.0

Leave a Reply

You must be logged in to post a comment.

RSS feed for comments on this question
« How do I see who is currently connected?

How to set a table in read-only mode ? »