COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID PK COMMENTS
ID NUMBER No null 1 1 Primary Key
SCHEMA_ID_FK NUMBER No null 2 null the schema in which this package resides //PARENTFIELD
NAME VARCHAR2(4000 BYTE) No null 3 null Name of this package //OBJECTNAME
PACKAGE_HEADER CLOB Yes null 4 null null
NATIVE_SQL CLOB Yes null 5 null The SQL used to create this package at source
NATIVE_KEY VARCHAR2(4000 BYTE) Yes null 6 null A unique identifer for this object at source.
LANGUAGE VARCHAR2(40 BYTE) No null 7 null //PUBLIC
COMMENTS VARCHAR2(4000 BYTE) Yes null 8 null null
SECURITY_GROUP_ID NUMBER No 0 9 null null
CREATED_ON DATE No sysdate 10 null null
CREATED_BY VARCHAR2(255 BYTE) Yes null 11 null null
LAST_UPDATED_ON DATE Yes null 12 null null
LAST_UPDATED_BY VARCHAR2(255 BYTE) Yes null 13 null null