select '[' || t1.audit_type || ']' || t2.name from audit_data_task_def t1 left join code_dict t2
on t2.catalog = 'T_AUDIT_METHOD' and t1.audit_type = t2.code;
select '[' || t1.audit_type || ']' || (select t.name from code_dict t where t.catalog = 'T_AUDIT_METHOD' and t.code = t1.audit_type)
from audit_data_task_def t1;