set lines 190 pages 200
col COMPONENT for a25
col COMP_TYPE for a15
select distinct 'select * from '||owner||'.svers;'
from dba_tables where table_name='USR02';
select distinct 'select * from '||owner||'.cvers;'
from dba_tables where table_name='USR02';
select * from SAPSR3.svers;
VERSION
----------
731 -- is Netweaver 7.31
select * from SAPSR3.cvers;
COMPONENT RELEASE EXTRELEASE COMP_TYPE
------------- --------------- ------------- -----------
PI_BASIS 731 0000000000 X
SAP_ABA 731 0000000000 S
SAP_BASIS 731 0000000000 S
SAP_BW 731 0000000000 W
ST-PI 2008_1_710 0000000004 X