查询Record中字段描述-PeoppleSoft

最新推荐文章于 2022-07-11 21:28:26 发布

原创最新推荐文章于 2022-07-11 21:28:26 发布 · 578 阅读

1 ·

CC 4.0 BY-SA版权

PeopleCode 专栏收录该内容

5 篇文章

订阅专栏

 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 = 1
ORDER BY C1.Fieldnum