demo@ORA12C> col bits format a40
demo@ORA12C> select job, trim('-' from sys_connect_by_path( x ,'-') ) bits
  2  from (
  3  select e2.job,
  4      decode(e2.job,e1.job,1,0) x, r
  5  from ( select row_number() over(order by empno) r, job from emp ) e1,
  6       ( select distinct job from emp ) e2
  7       )
  8  where connect_by_isleaf = 1
  9  start with r = 1
 10  connect by prior job = job
 11    and prior r = r-1
 12  /

JOB       BITS
--------- ----------------------------------------
ANALYST   0-0-0-0-0-0-0-1-0-0-0-0-1-0
CLERK     1-0-0-0-0-0-0-0-0-0-1-1-0-1
MANAGER   0-0-0-1-0-1-1-0-0-0-0-0-0-0
PRESIDENT 0-0-0-0-0-0-0-0-1-0-0-0-0-0
SALESMAN  0-1-1-0-1-0-0-0-0-1-0-0-0-0

demo@ORA12C>

select j.job,
  listagg(decode(j.job, e.job, 1, 0)) within group(order by e.rowid) bitmap
from emp e,
(select distinct job from emp) j
group by j.job;

JOB         BITMAP           
ANALYST     00000001000010   
CLERK       10000000001101   
MANAGER     00010110000000   
PRESIDENT   00000000100000   
SALESMAN    01101000010000 

with data(compass_point) as (
  select 'N' from dual
  union all
  select 'E' from dual
  union all
  select 'S' from dual
  union all
  select 'W' from dual
)
select decode(compass_point,'N',1,0) N,
  decode(compass_point,'E',1,0) E,
  decode(compass_point,'S',1,0) S,
  decode(compass_point,'W',1,0) W
from data;

N   E   S   W   
1   0   0   0 
0   1   0   0 
0   0   1   0 
0   0   0   1