Results 1 to 3 of 3

Thread: oracle version

  1. #1
    Join Date
    Nov 2003
    Posts
    13

    Question Unanswered: oracle version

    hi

    can i know the version of the oracle data base on which i am working??
    is there any command or query which i can type either in toad or SQLPLUS
    to know the database version?

    regards
    Sai koushal

  2. #2
    Join Date
    Jul 2003
    Location
    England
    Posts
    152
    select * from v$version will give you what you want.
    Regards
    Dbabren

  3. #3
    Join Date
    Mar 2004
    Location
    Berkshire, UK
    Posts
    186
    this will also tell you the versions of all oracle installed modules (eg java, intermedia)

    select comp_id, version, status from dba_registry;
    There are 10 types of people in the world, those that know Binary and those that don't.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •