select substr(global_name, 1, Instr(global_name,'.')-1) ||
*

SELECT ('AR Version : '||max(genutil.srelease(turvers_release)))
*

SELECT * from v$version
*

select 'Patch ID : ' || rtrim(GURPOST_PATCH) ||
*

select '...generated by bannerversionspartial01...' from dual
*