PSRECDEFNPVW

index back

Rec Defn Prompt View

Record Definition Prompt view - where criteria limits RecType to Tables and Views
SELECT A.RECNAME ,A.RECDESCR ,A.RECTYPE ,A.DESCRLONG FROM PSRECDEFN A WHERE A.RECTYPE NOT IN (2,3,7)

BEGIN ptref.pthtml('PSRECDEFNPVW'); END; * ERROR at line 1: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "SYSADM.PTREF", line 33 ORA-06512: at "SYSADM.PTREF", line 146 ORA-06512: at line 1