Re: SQLPlus version tracking
- From: Yong Huang <yong321@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 20 Jan 2012 14:57:03 -0800 (PST)
> With some experiment, I think the widths of the numbers are
> 2, 1, 2, 1, 2 bytes, respectively. So we can use the
> following SQL to check the client version (run as sys):
> ...
A better SQL for an 11g database to check its client version:
with x as (select distinct to_char(ksuseclvsn,'xxxxxxx') v
from x$ksusecon where ksusenum = &sid)
select decode(v, ' 0', '10g or lower',
to_number(substr(v,1,2),'xx') || '.' || --maj_rel
to_number(substr(v,3,1),'x') || '.' || --mnt_rel
to_number(substr(v,4,2),'xx') || '.' || --ias_rel
to_number(substr(v,6,1),'x') || '.' || --ptc_set
to_number(substr(v,7,2),'xx')) client_version -- port_mnt
from x;
Have a good weekend!
Yong Huang
--
//www.freelists.org/webpage/oracle-l
Other related posts:
