Results 1 to 3 of 3

Thread: Getting Oracle version number

  1. #1
    Join Date
    Feb 2004
    Posts
    24

    Getting Oracle version number

    What SQL statement would I use to get the version of Oracle I am using? For example, I would like to know what patch I currently have installed. I know I have version 8.1.7.? installed (where ? is the patch number), but don't know which patch version. Is there a view that I can query to get this information? If so, which one?

    Thanks in advance,
    shava

  2. #2
    Join Date
    Mar 2003
    Posts
    468
    select * from v$version

  3. #3
    Join Date
    Sep 2004
    Posts
    1
    Apart from v$version, one can use
    "select * from product_component_version" also...

    product_component_version Structure is -
    product varchar2(64),
    version varchar2(64),
    status varchar2(64)

Posting Permissions

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