SELECT f.tabname, f.fieldname, t.ddtext, ltrim(position,'0') as position, f.keyflag as "Primary Key", d.rollname as "Data Element", d.domname as "Domain", d.memoryid, f.datatype, ltrim(f.leng,'0') as leng, f.checktable, f.reftable, f.reffield, m.entitytab, m.convexit FROM dd03l f, dd04l d, dd04t t, dd01L m WHERE d.rollname(+) = f.rollname AND t.rollname = d.rollname AND m.domname(+) = d.domname ..