Shortzzz' Blog: pivot

Posts mit dem Label pivot werden angezeigt. Alle Posts anzeigen

Freitag, 2. Mai 2014

Tabelle Flachklopfen

 SELECT * FROM (  
 SELECT 'OA' OBJECT_NAME, 'EU' REGION FROM DUAL UNION ALL  
 SELECT 'OB' OBJECT_NAME, 'EU' REGION FROM DUAL UNION ALL  
 SELECT 'OC' OBJECT_NAME, 'EU' REGION FROM DUAL UNION ALL  
 SELECT 'OA' OBJECT_NAME, 'US' REGION FROM DUAL UNION ALL  
 SELECT 'OB' OBJECT_NAME, 'AS' REGION FROM DUAL UNION ALL  
 SELECT 'OC' OBJECT_NAME, 'AS' REGION FROM DUAL ) S  
 PIVOT (COUNT (*) FOR REGION IN ('EU', 'US', 'AS'))