COLUMN "PARAMETROS ESTABLECIDOS" FORMAT A145

SELECT LPAD(' ',(LEVEL-1)*6)||'K/'||KEYID||'- C/'||CLASE||'- P/'||PARAMETRO||'->'||VALOR||'-P2/'||PARAMETRO2||'->'||VALOR2 "PARAMETROS ESTABLECIDOS"
FROM astsysadmin.T_PARAMETROS
where clase like upper('%&1%')
start with PARENTKEYID is null
CONNECT BY PARENTKEYID = PRIOR KEYID
order by keyid;

SELECT LPAD(' ',(LEVEL-1)*6)||'K/'||KEYID||'- C/'||CLASE||'- P/'||PARAMETRO||'->'||VALOR||'-P2/'||PARAMETRO2||'->'||VALOR2 "PARAMETROS ESTABLECIDOS"
FROM acc_admin.T_PARAMETROS
where clase like upper('%&1%')
start with PARENTKEYID is null
CONNECT BY PARENTKEYID = PRIOR KEYID
order by keyid;
