oracle sql

select * from (
select t.*,level lv,connect_by_isleaf isleaf from TB_INFRA_CODEITEM t connect by prior code=parent_id start with CODESET_ID='3048' and parent_id='-1'
) a order by code