Data Element / Domain info SQL

*--- Data Element search
select l.rollname, l.datatype, l.leng, l.decimals, l.signflag
     , t.ddtext, t.reptext
  from dd04l l
     , dd04t t
 where t.rollname   = l.rollname
   and t.ddlanguage = '3'
   and t.as4local   = l.as4local
   and t.as4vers    = l.as4vers
  
   and t.ddtext like '%지연%'

*--- Domain search
select l.domname, l.datatype, l.leng, l.decimals, l.signflag
     , t.ddtext
  from dd01l l
     , dd01t t
 where t.domname   = l.domname
   and t.ddlanguage = '3'
   and t.as4local   = l.as4local
   and t.as4vers    = l.as4vers
  
   and t.ddtext like '%지연%'