1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Oracle version

Discussion in 'General' started by noufal_y, Sep 15, 2009.

  1. noufal_y

    noufal_y Forum Advisor

    Messages:
    38
    Likes Received:
    0
    Trophy Points:
    80
    Hi all,

    When i connect to SQL it shows connecting to Oracle 10g Enterprise Edition and will get connected. Our developer given the documents b4 when i joined here as standard edition installed on production, standby and collateral.

    How can i get to know which edition is installed in the server.
    Please help me

    Thanks
     
  2. Shekhar81

    Shekhar81 Active Member

    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    80
    Look at the banner when you login with sqlplus or run this query

    Code (SQL):
    SELECT * FROM v$version;