This is rather convoluted, and far easier using regex in more recent
versions, but since you're checking for gt 8, it won't be available. So,
you can use the following SQL.
with vb as
( select banner,
instr(banner,'Release') + length('Release') + 1 as istart,
instr(banner, '-') - 1 as iend
from v$version
where banner like '%Oracle%' )
select substr(vb.banner,vb.istart,vb.iend-vb.istart) from vb;
Or try upgrading. :)
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[email protected]
