(select
substr(banner,1, instr(banner,'Version')-1),
substr(banner, instr(banner,'Version')+8,
instr(banner,' - ')-(instr(banner,'Version')+8)),
substr(banner,instr(banner,' - ')+3)
from v$version
where instr(banner,'Version') > 0
and
((instr(banner,'Version') < instr(banner,'Release')) or
instr(banner,'Release') = 0))
union
(select
substr(banner,1, instr(banner,'Release')-1),
substr(banner, instr(banner,'Release')+8,
instr(banner,' - ')-(instr(banner,'Release')+8)),
substr(banner,instr(banner,' - ')+3)
from v$version
where instr(banner,'Release') > 0
and
instr(banner,'Release') < instr(banner,' - '))
(SELECT
SUBSTR(BANNER
, 1
, INSTR(BANNER
, 'VERSION')-1)
,
SUBSTR(BANNER
, INSTR(BANNER
, 'VERSION')+8
,
INSTR(BANNER
, ' - ')-(INSTR(BANNER
, 'VERSION')+8))
,
SUBSTR(BANNER
, INSTR(BANNER
, ' - ')+3)
FROM V$VERSION
WHERE INSTR(BANNER
, 'VERSION') > 0
AND
((INSTR(BANNER
, 'VERSION') < INSTR(BANNER
, 'RELEASE')) OR
INSTR(BANNER
, 'RELEASE') = 0))
UNION
(SELECT
SUBSTR(BANNER
, 1
, INSTR(BANNER
, 'RELEASE')-1)
,
SUBSTR(BANNER
, INSTR(BANNER
, 'RELEASE')+8
,
INSTR(BANNER
, ' - ')-(INSTR(BANNER
, 'RELEASE')+8))
,
SUBSTR(BANNER
, INSTR(BANNER
, ' - ')+3)
FROM V$VERSION
WHERE INSTR(BANNER
, 'RELEASE') > 0
AND
INSTR(BANNER
, 'RELEASE') < INSTR(BANNER
, ' - '))
|
|
|