By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
30 rows affected
7 rows affected
HIRE YEAR | A c c o u n t a n t | A u d i t o r | P r e s i d e n t | S a l e s M a n a g e r | S t o c k C l e r k |
---|---|---|---|---|---|
2001 | 0 | 0 | 0 | 0 | 1 |
2003 | 0 | 1 | 0 | 0 | 0 |
2005 | 0 | 0 | 1 | 1 | 0 |
2006 | 0 | 0 | 0 | 2 | 0 |
2007 | 1 | 0 | 0 | 0 | 0 |
HIRE YEAR | A c c o u n t a n t | A u d i t o r | P r e s i d e n t | S a l e s M a n a g e r | S t o c k C l e r k |
---|---|---|---|---|---|
2001 | 0 | 0 | 0 | 0 | 1 |
2003 | 0 | 1 | 0 | 0 | 0 |
2005 | 0 | 0 | 1 | 1 | 0 |
2006 | 0 | 0 | 0 | 2 | 0 |
2007 | 1 | 0 | 0 | 0 | 0 |
v_cols |
---|
SUM( CASE WHEN job_title = 'T a x A c c o u n t a n t' THEN 1 ELSE 0 END ) AS "T a x A c c o u n t a n t",SUM( CASE WHEN job_title = 'D a t a b a s e A d m i n i s t r a t o r' THEN 1 ELSE 0 END ) AS "D a t a b a s e A d m i n i s t r a t o r",SUM( CASE WHEN job_title = 'F i n a n c e M a n a g e r' THEN 1 ELSE 0 END ) AS "F i n a n c e M a n a g e r",SUM( CASE WHEN job_title = 'P u b l i c R e l a t i o n s R e p r e s e n t a t i v e' THEN 1 ELSE 0 END ) AS "P u b l i c R e l a t i o n s R e p r e s e n t a t i v e",SUM( CASE WHEN job_title = 'S a l e s R e p r e s e n t a t i v e' THEN 1 ELSE 0 END ) AS "S a l e s R e p r e s e n t a t i v e",SUM( CASE WHEN job_title = 'S h i p p i n g C l e r k' THEN 1 ELSE 0 END ) AS "S h i p p i n g C l e r k",SUM( CASE WHEN job_title = 'S t o c k M a n a g e r' THEN 1 ELSE 0 END ) AS "S t o c k M a n a g e r",SUM( CASE WHEN job_title = 'F o r e n s i c A c c o u n t a n t' THEN 1 ELSE 0 END ) AS "F o r e n s i c A c c o u n t a n t",SUM( CASE WHEN job_title = 'A d m i n i s t r a t i o n V i c e P r e s i d e n t' THEN 1 ELSE 0 END ) AS "A d m i n i s t r a t i o n V i c e P r e s i d e n t",SUM( CASE WHEN job_title = 'A c c o u n t a n t' THEN 1 ELSE 0 END ) AS "A c c o u n t a n t",SUM( CASE WHEN job_title = 'S o f t w a r e D e v e l o p e r' THEN 1 ELSE 0 END ) AS "S o f t w a r e D e v e l o p e r",SUM( CASE WHEN job_title = 'M a r k e t i n g A s s i s t a n t' THEN 1 ELSE 0 END ) AS "M a r k e t i n g A s s i s t a n t",SUM( CASE WHEN job_title = 'A d m i n i s t r a t i o n A s s i s t a n t' THEN 1 ELSE 0 END ) AS "A d m i n i s t r a t i o n A s s i s t a n t",SUM( CASE WHEN job_title = 'C u s t o m e r S u c c e s s M a n a g e r' THEN 1 ELSE 0 END ) AS "C u s t o m e r S u c c e s s M a n a g e r",SUM( CASE WHEN job_title = 'D i g i t a l M a r k e t i n g M a n a g e r' THEN 1 ELSE 0 END ) AS "D i g i t a l M a r k e t i n g M a n a g e r",SUM( CASE WHEN job_title = 'S a l e s M a n a g e r' THEN 1 ELSE 0 END ) AS "S a l e s M a n a g e r",SUM( CASE WHEN job_title = 'A c c o u n t i n g M a n a g e r' THEN 1 ELSE 0 END ) AS "A c c o u n t i n g M a n a g e r",SUM( CASE WHEN job_title = 'A u d i t o r' THEN 1 ELSE 0 END ) AS "A u d i t o r",SUM( CASE WHEN job_title = 'B u d g e t A n a l y s t' THEN 1 ELSE 0 END ) AS "B u d g e t A n a l y s t",SUM( CASE WHEN job_title = 'H u m a n R e s o u r c e s R e p r e s e n t a t i v e' THEN 1 ELSE 0 END ) AS "H u m a n R e s o u r c e s R e p r e s e n t a t i v e",SUM( CASE WHEN job_title = 'M a r k e t i n g C o o r d i n a t o r' THEN 1 ELSE 0 END ) AS "M a r k e t i n g C o o r d i n a t o r",SUM( CASE WHEN job_title = 'M a r k e t i n g R e p r e s e n t a t i v e' THEN 1 ELSE 0 END ) AS "M a r k e t i n g R e p r e s e n t a t i v e",SUM( CASE WHEN job_title = 'P u r c h a s i n g C l e r k' THEN 1 ELSE 0 END ) AS "P u r c h a s i n g C l e r k",SUM( CASE WHEN job_title = 'S t o c k C l e r k' THEN 1 ELSE 0 END ) AS "S t o c k C l e r k",SUM( CASE WHEN job_title = 'P u b l i c A c c o u n t a n t' THEN 1 ELSE 0 END ) AS "P u b l i c A c c o u n t a n t",SUM( CASE WHEN job_title = 'P r e s i d e n t' THEN 1 ELSE 0 END ) AS "P r e s i d e n t",SUM( CASE WHEN job_title = 'A c c o u n t s P a y a b l e S p e c i a l i s t' THEN 1 ELSE 0 END ) AS "A c c o u n t s P a y a b l e S p e c i a l i s t",SUM( CASE WHEN job_title = 'M a r k e t i n g M a n a g e r' THEN 1 ELSE 0 END ) AS "M a r k e t i n g M a n a g e r",SUM( CASE WHEN job_title = 'N e t w o r k A d m i n i s t r a t o r' THEN 1 ELSE 0 END ) AS "N e t w o r k A d m i n i s t r a t o r",SUM( CASE WHEN job_title = 'P u r c h a s i n g M a n a g e r' THEN 1 ELSE 0 END ) AS "P u r c h a s i n g M a n a g e r" |
44 rows affected
ORA-01489: result of string concatenation is too long
v_cols |
---|
SUM( CASE WHEN job_title = 'A c c o u n t a n t' THEN 1 ELSE 0 END ) AS "A c c o u n t a n t",SUM( CASE WHEN job_title = 'A c c o u n t i n g M a n a g e r' THEN 1 ELSE 0 END ) AS "A c c o u n t i n g M a n a g e r",SUM( CASE WHEN job_title = 'A c c o u n t s P a y a b l e S p e c i a l i s t' THEN 1 ELSE 0 END ) AS "A c c o u n t s P a y a b l e S p e c i a l i s t",SUM( CASE WHEN job_title = 'A d m i n i s t r a t i o n A s s i s t a n t' THEN 1 ELSE 0 END ) AS "A d m i n i s t r a t i o n A s s i s t a n t",SUM( CASE WHEN job_title = 'A d m i n i s t r a t i o n V i c e P r e s i d e n t' THEN 1 ELSE 0 END ) AS "A d m i n i s t r a t i o n V i c e P r e s i d e n t",SUM( CASE WHEN job_title = 'A u d i t o r' THEN 1 ELSE 0 END ) AS "A u d i t o r",SUM( CASE WHEN job_title = 'B u d g e t A n a l y s t' THEN 1 ELSE 0 END ) AS "B u d g e t A n a l y s t",SUM( CASE WHEN job_title = 'C u s t o m e r S u c c e s s M a n a g e r' THEN 1 ELSE 0 END ) AS "C u s t o m e r S u c c e s s M a n a g e r",SUM( CASE WHEN job_title = 'D a t a b a s e A d m i n i s t r a t o r' THEN 1 ELSE 0 END ) AS "D a t a b a s e A d m i n i s t r a t o r",SUM( CASE WHEN job_title = 'D i g i t a l M a r k e t i n g M a n a g e r' THEN 1 ELSE 0 END ) AS "D i g i t a l M a r k e t i n g M a n a g e r",SUM( CASE WHEN job_title = 'F i n a n c e M a n a g e r' THEN 1 ELSE 0 END ) AS "F i n a n c e M a n a g e r",SUM( CASE WHEN job_title = 'F o r e n s i c A c c o u n t a n t' THEN 1 ELSE 0 END ) AS "F o r e n s i c A c c o u n t a n t",SUM( CASE WHEN job_title = 'H u m a n R e s o u r c e s R e p r e s e n t a t i v e' THEN 1 ELSE 0 END ) AS "H u m a n R e s o u r c e s R e p r e s e n t a t i v e",SUM( CASE WHEN job_title = 'M a r k e t i n g A s s i s t a n t' THEN 1 ELSE 0 END ) AS "M a r k e t i n g A s s i s t a n t",SUM( CASE WHEN job_title = 'M a r k e t i n g C o o r d i n a t o r' THEN 1 ELSE 0 END ) AS "M a r k e t i n g C o o r d i n a t o r",SUM( CASE WHEN job_title = 'M a r k e t i n g M a n a g e r' THEN 1 ELSE 0 END ) AS "M a r k e t i n g M a n a g e r",SUM( CASE WHEN job_title = 'M a r k e t i n g R e p r e s e n t a t i v e' THEN 1 ELSE 0 END ) AS "M a r k e t i n g R e p r e s e n t a t i v e",SUM( CASE WHEN job_title = 'N e t w o r k A d m i n i s t r a t o r' THEN 1 ELSE 0 END ) AS "N e t w o r k A d m i n i s t r a t o r",SUM( CASE WHEN job_title = 'P r e s i d e n t' THEN 1 ELSE 0 END ) AS "P r e s i d e n t",SUM( CASE WHEN job_title = 'P u b l i c A c c o u n t a n t' THEN 1 ELSE 0 END ) AS "P u b l i c A c c o u n t a n t",SUM( CASE WHEN job_title = 'P u b l i c R e l a t i o n s R e p r e s e n t a t i v e' THEN 1 ELSE 0 END ) AS "P u b l i c R e l a t i o n s R e p r e s e n t a t i v e",SUM( CASE WHEN job_title = 'P u r c h a s i n g C l e r k' THEN 1 ELSE 0 END ) AS "P u r c h a s i n g C l e r k",SUM( CASE WHEN job_title = 'P u r c h a s i n g M a n a g e r' THEN 1 ELSE 0 END ) AS "P u r c h a s i n g M a n a g e r",SUM( CASE WHEN job_title = 'S a l e s M a n a g e r' THEN 1 ELSE 0 END ) AS "S a l e s M a n a g e r",SUM( CASE WHEN job_title = 'S a l e s R e p r e s e n t a t i v e' THEN 1 ELSE 0 END ) AS "S a l e s R e p r e s e n t a t i v e",SUM( CASE WHEN job_title = 'S h i p p i n g C l e r k' THEN 1 ELSE 0 END ) AS "S h i p p i n g C l e r k",SUM( CASE WHEN job_title = 'S o f t w a r e D e v e l o p e r' THEN 1 ELSE 0 END ) AS "S o f t w a r e D e v e l o p e r",SUM( CASE WHEN job_title = 'S t o c k C l e r k' THEN 1 ELSE 0 END ) AS "S t o c k C l e r k",SUM( CASE WHEN job_title = 'S t o c k M a n a g e r' THEN 1 ELSE 0 END ) AS "S t o c k M a n a g e r",THE REST IS TRUNCATED |