SELECT 'TABLE', 
       Decode(temporary, 'N', 1, 
                         0) 
FROM   all_all_tables T 
WHERE  T.table_name = 'TABLE_NAME' 
       AND T.owner = 'TIQOWNER' 
       AND T.nested = 'NO' 
       AND T.dropped = 'NO' 
UNION 
SELECT 'PKIDX', 
       Count(*) 
FROM   all_constraints AC, 
       all_indexes IDX, 
       all_all_tables T 
WHERE  CASE 
         WHEN AC.index_owner IS NOT NULL THEN AC.index_owner 
         ELSE AC.owner 
       END = IDX.owner 
       AND AC.index_name = IDX.index_name 
       AND AC.constraint_type = 'P' 
       AND AC.validated = 'VALIDATED' 
       AND AC.status = 'ENABLED' 
       AND IDX.status = 'VALID' 
       AND AC.table_name = 'SD_TRADING_GROUP' 
       AND AC.owner = 'TIQOWNER' 
       AND CASE 
             WHEN AC.index_owner IS NOT NULL THEN AC.index_owner 
             ELSE AC.owner 
           END = T.owner 
       AND AC.table_name = T.table_name 
       AND T.dropped = 'NO' 
UNION 
SELECT 'PKCOL', 
       Count(*) 
FROM   all_constraints AC, 
       all_tab_columns TC, 
       all_cons_columns CC 
WHERE  AC.owner = TC.owner 
       AND AC.table_name = TC.table_name 
       AND AC.owner = CC.owner 
       AND AC.table_name = CC.table_name 
       AND CC.column_name = TC.column_name;