add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
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