Home » SQL & PL/SQL » SQL & PL/SQL » how to find out client version from SQL command.
how to find out client version from SQL command. [message #170447] Wed, 03 May 2006 21:55 Go to next message
Ivancleber da Silva Neves
Messages: 74
Registered: July 2002
Member
How to find out oracle client version through a sql command ?

Thanks in advance
Re: How to find out oracle client version through a sql command ? [message #170499 is a reply to message #170447] Thu, 04 May 2006 01:44 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
You don't. SQL is launched against the database, the server. You, on the other hand, are working on the client (normally). You should know what tools you use.

MHE
From my session how to find out the version of my oracle client ? [message #279599 is a reply to message #170447] Fri, 09 November 2007 05:14 Go to previous messageGo to next message
Ivancleber da Silva Neves
Messages: 74
Registered: July 2002
Member
From my session how to find out the version of my oracle client ?

Thanks in advance
Re: From my session how to find out the version of my oracle client ? [message #279602 is a reply to message #279599] Fri, 09 November 2007 06:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You can't (unless you trace SQL*Net packets).
How does this matter?

Regards
Michel
Re: From my session how to find out the version of my oracle client ? [message #279617 is a reply to message #279602] Fri, 09 November 2007 07:07 Go to previous messageGo to next message
Ivancleber da Silva Neves
Messages: 74
Registered: July 2002
Member
I have to find out what version of oracle client some machines are using. How can I do this ? Any suggestion ?


Thanks in advance
Re: From my session how to find out the version of my oracle client ? [message #279618 is a reply to message #279617] Fri, 09 November 2007 07:10 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Nope. You can't. Not through your Oracle database.

MHE
Re: From my session how to find out the version of my oracle client ? [message #279644 is a reply to message #279617] Fri, 09 November 2007 08:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Why do you have to know this?

Regards
Michel
Re: From my session how to find out the version of my oracle client ? [message #279645 is a reply to message #279617] Fri, 09 November 2007 08:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
By the way don't you notice we give the same answer as when you previously asked it in http://www.orafaq.com/forum/m/170447/102589/#msg_170447?

Regards
Michel

[Updated on: Fri, 09 November 2007 08:54]

Report message to a moderator

Re: From my session how to find out the version of my oracle client ? [message #282374 is a reply to message #279645] Wed, 21 November 2007 13:40 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
http://www.pythian.com/blogs/669/tracking-your-oracle-client-versions-in-11g
Re: From my session how to find out the version of my oracle client ? [message #283332 is a reply to message #282374] Mon, 26 November 2007 14:18 Go to previous messageGo to next message
srinivasanram2004
Messages: 2
Registered: August 2007
Junior Member
Can't you use

select banner from v$version;

or

SELECT *
FROM PRODUCT_COMPONENT_VERSION;
Re: From my session how to find out the version of my oracle client ? [message #283336 is a reply to message #283332] Mon, 26 November 2007 14:53 Go to previous message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
These give server and not client version.

Regards
Michel
Previous Topic: PLS-00103: Encountered the symbol "(" when expecting one of the f ollowing: := . ) , @ % d
Next Topic: update query problem
Goto Forum:
  


Current Time: Sun Feb 16 00:36:27 CST 2025