select * from (select tablespace_name, table_name, num_rows from dba_tables) pivot (sum(num_rows) for table_name in ('MB_JSBSF' as MB_JSBSF, 'MB_JSBSFYY' MB_JSBSFYY, 'MB_JSBSFYY_BAK' MB_JSBSFYY_BAK, 'MB_JSBXX' MB_JSBXX,'SYS_BZFL' SYS_BZFL));
;
;