查找KEY
---keys SELECT FIELDNAME FROM PSRECFIELD WHERE RECNAME = 'JOB' AND BITAND(USEEDIT,1) > 0 |
查找search keys
--- search keys SELECT FIELDNAME FROM PSRECFIELD WHERE RECNAME = 'JOB' AND BITAND(USEEDIT,2048) > 0 |
查找alternater search keys
---alternate search keys SELECT FIELDNAME FROM PSRECFIELD WHERE RECNAME = 'JOB' AND BITAND(USEEDIT,16) > 0 |
查找required fields
--Required fields SELECT A.FIELDNAME FROM PSRECFIELD A WHERE A.RECNAME = 'JOB' AND bitand(A.USEEDIT, 256) > 0 |
截图：
纯文本：
| Search Edit 268435456 Related Language Record 33554432 (set for all the non-key fields that are in the Related Language Record) Default Search Field 16777216 Use Default Label (Record Field Label ID) 8388608 Disable Advanced Search Options 2097152 Through Search Field 524288 From Search Field 262144 Auto Update 32768 Prompt Table Edit 16384 Y/N Edit 8192 Reasonable Date 4096 Search Key 2048 Audit Delete 1024 Xlat Edit 512 Required 256 Audit Change 128 Desc Key 64 List Box 32 Alt Search Key 16 Audit Add 8 System Maintained 4 Duplicate Key 2 Key 1 |
更多资料：https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=17c0jxyh82_4&_afrLoop=251468847800639
字数问题字数问题字数问题字数问题字字数问题字数问题字数问题数问题字数问题字数问题字数问题字数问题字数问题字数问题字数问题字数问题字数问题字数问题字数问题字数问题字数问题字数问题字数问题字数问题字数问题字数问题字数问题字数问题字字数问题字数问题字数问题数问题字数问题字数问题字数问题字数问题字数问题字数问题字数问题字数问题字数问题字数问题字数问题字数问题字数问题字数问题字数问题字数问题
