colors-all.sql

with colors as ( 
    select 'black' value  from dual
    union all
    select 'green'   from dual
    union all
    select 'yellow'   from dual
    union all
    select 'blue'   from dual
    union all
    select 'magenta'   from dual
    union all
    select 'cyan'   from dual
    union all
    select 'white'   from dual

) ,
bg as ( 
    select 'bg_black' value  from dual
    union all
    select 'bg_green'   from dual
    union all
    select 'bg_yellow'   from dual
    union all
    select 'bg_blue'   from dual
    union all
    select 'bg_magenta'   from dual
    union all
    select 'bg_cyan'   from dual
    union all
    select 'bg_white'   from dual
),
fg as ( 
    select 'bg_black' value  from dual
    union all
    select 'bg_green'   from dual
    union all
    select 'bg_yellow'   from dual
    union all
    select 'bg_blue'   from dual
    union all
    select 'bg_magenta'   from dual
    union all
    select 'bg_cyan'   from dual
    union all
    select 'bg_white'   from dual
),
attr as ( 
    select 'BLINK_FAST' value from dual 
        union all
    select 'BLINK_OFF' from dual
        union all
    select 'BLINK_SLOW' from dual
        union all
    select 'CONCEAL_OFF' from dual
        union all
    select 'CONCEAL_ON' from dual
        union all
    select 'INTENSITY_BOLD' from dual
        union all
    select 'INTENSITY_FAINT' from dual
        union all
    select 'ITALIC' from dual
        union all
    select 'NEGATIVE_OFF' from dual
        union all
    select 'NEGATIVE_ON' from dual
        union all
    select 'RESET' from dual
        union all
    select 'UNDERLINE' from dual
        union all
    select 'UNDERLINE_DOUBLE' from dual
        union all
    select 'UNDERLINE_OFF' from dual
)
select  colors.value "Color",bg.value "BG",fg.value "FG",attr.value "Attr",
        '@|'||colors.value||','||bg.value||','||fg.value||','||attr.value||' Test Me|@' "xx"
from colors,bg,fg,attr;