Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Displaying Oracle Client Version Number

Re: Displaying Oracle Client Version Number

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 29 May 2003 09:16:26 -0700
Message-ID: <92eeeff0.0305290816.3980199d@posting.google.com>


ian.smith_at_coabis.com (Ian Smith) wrote in message news:<a3e5d37f.0305290116.640020b9_at_posting.google.com>...
> Hi,
>
> Does anyone out there know how to display the exact version number of
> the Oracle Client being used?
>
> Oracle don't appear to use version numbers in their DLL's properties
> and nls parameters only store the version number of the Database.
>
> Thanks,
>
> Ian

  1. From command line, launch sqlplus /nolog and look for version after "SQL*Plus: Release" in the header part.
  2. In a batch script, FOR /F "tokens=1-3 delims= " %%A in ('echo exit ^| sqlplus /nolog ^| find /i "sql*plus"') do echo %%C
  3. Look for highest patch number directory under C:\Program Files\Oracle\Inventory\PatchSets. This inventory directory location is default at install time... you may have chosen a different one.

Regards
/Rauf Sarwar Received on Thu May 29 2003 - 11:16:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US