查询Record中字段描述-PeoppleSoft

 SELECT A1.FIELDNAME,        D1.SHORTNAME,        DECODE(E1.DATA_TYPE,               'VARCHAR2',               E1.DATA_TYPE || '(' || E1.DATA_LENGTH / 3 || ')',               'NUMBER',               CASE E1.DATA_SCALE                 WHEN 0 THEN                  'INTEGER'                 ELSE                  E1.DATA_TYPE || '(' || E1.DATA_PRECISION || ',' ||                  e1.DATA_SCALE || ')'               END,               E1.DATA_TYPE)   FROM PSRECFIELDALL   A1,        PSDBFIELD       B1,        PSRECFIELD      C1,        PSDBFLDLABL     D1,        DBA_TAB_COLUMNS E1  WHERE A1.RECNAME = C1.RECNAME    AND A1.FIELDNAME = C1.FIELDNAME    AND A1.RECNAME =&RecordName    AND E1.TABLE_NAME = CONCAT('PS_', A1.RECNAME)    AND A1.FIELDNAME = E1.COLUMN_NAME    AND C1.SUBRECORD = 'N'    AND B1.FIELDNAME = C1.FIELDNAME    AND C1.FIELDNAME = D1.FIELDNAME    AND D1.DEFAULT_LABEL = 1ORDER BY C1.Fieldnum