| Sql query for display client version. [message #433611] |
Thu, 03 December 2009 05:08  |
deep0983
Messages: 28
Registered: April 2009
|
Junior Member |
|
|
Hello All,
SQL*Plus: Release 11.1.0.6.0 - Production on Thu Dec 3 16:16:28 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
As you can see in above connection detail i am using oracle 11 client to connect with oracle 10 now i want to display installed oracle client version with the help of sql query? by connecting to the database.
Any suggesstion much appreciated.
Thanks in advance.
|
|
|
|
| Re: Sql query for display client version. [message #433613 is a reply to message #433611] |
Thu, 03 December 2009 05:15  |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
There's definitely no way of getting this information back from the database, as it's purely client information.
A quick scan through the SQL*Plus guide doesn't show any way of getting it to repeat the information either, I'm afraid.
|
|
|
|
|
|
|
|
| Re: Sql query for display client version. [message #433624 is a reply to message #433615] |
Thu, 03 December 2009 05:38 |
 |
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
|
Senior Member |
|
|
How this will be the answer for OP.
He/She wants the client version Not the Server.
If not if the op`s requirement is for server then so many ways.
SQL> select '&&_O_VERSION' as "Oracle Client Version" from dual ;
Oracle Clien
------------
&&_O_VERSION
SQL>
SQL> set scan on
SQL> select '&&_O_VERSION' as "Oracle Client Version" from dual ;
Oracle Client Version
-----------------------------------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> select '&&_SQLPLUS_RELEASE' as "SQLPLUS_RELEASE" from dual ;
SQLPLUS_RE
----------
1002000100
SQL> select banner from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
SQL>
sriram 
[Updated on: Thu, 03 December 2009 05:40] Report message to a moderator |
|
|
|
| Re: Sql query for display client version. [message #433626 is a reply to message #433611] |
Thu, 03 December 2009 05:41 |
cookiemonster
Messages: 13960
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
That is the client version - as long as your client is sqlplus.
SQL*Plus: Release 9.0.1.4.0 - Production on Thu Dec 3 11:41:11 2009
(c) Copyright 2001 Oracle Corporation. All rights reserved.
Connected to:
Oracle Database 10g Release 10.2.0.2.0 - 64bit Production
SQL> select '&_SQLPLUS_RELEASE' from dual;
old 1: select '&_SQLPLUS_RELEASE' from dual
new 1: select '900010400' from dual
'90001040
---------
900010400
SQL>
|
|
|
|
| Re: Sql query for display client version. [message #433627 is a reply to message #433626] |
Thu, 03 December 2009 05:47 |
|
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
|
Senior Member |
|
|
OK its my mistake i tested that On my 10.2.0.1 server(having both client /server same version)
SQL*Plus: Release 10.2.0.3.0 - Production on Thu Dec 3 17:16:16 2009
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ind> select '&_SQLPLUS_RELEASE' from dual;
old 1: select '&_SQLPLUS_RELEASE' from dual
new 1: select '1002000300' from dual
'100200030
----------
1002000300
1 row selected.
ind> select '&&_SQLPLUS_RELEASE' as "SQLPLUS_RELEASE" from dual ;
old 1: select '&&_SQLPLUS_RELEASE' as "SQLPLUS_RELEASE" from dual
new 1: select '1002000300' as "SQLPLUS_RELEASE" from dual
SQLPLUS_RE
----------
1002000300
1 row selected.
Tested on 9i client..
SQL*Plus: Release 9.2.0.1.0 - Production on Thu Dec 3 17:21:30 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> select '&_SQLPLUS_RELEASE' from dual;
old 1: select '&_SQLPLUS_RELEASE' from dual
new 1: select '902000100' from dual
'90200010
---------
902000100
http://www.lazydba.com/oracle/0__12424.html
[Updated on: Thu, 03 December 2009 05:53] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: Sql query for display client version. [message #433633 is a reply to message #433628] |
Thu, 03 December 2009 06:42 |
cookiemonster
Messages: 13960
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
Michel Cadot wrote on Thu, 03 December 2009 11:58@ramoradba, @cookiemonster
Why do you repeat what I posted before?
To prove to ramoradba that your solution shows the client version rather than the server version.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
there is 1 min difference too.Just kidding.