The IN_OBJECTS type is a record type that contains the following list of fields which are used by the IN_OBJECT_DDL table type to store a collection of objects and associated SQL commands.
TYPE IN_OBJECTS IS RECORD ( OBJECT_NAME VARCHAR2(257), SUBOBJECT_NAME VARCHAR2(128), OBJECT_SQL VARCHAR2(2000) );
| Field Name | Description |
|---|---|
| OBJECT_NAME | The name of the object. This is usually the table name associated with the SUBOBJECT_NAME. |
| SUBOBJECT_NAME | The name of the sub-object. This could be an index name, a constraint name, or a column name. |
| OBJECT_SQL | The SQL associated with the object. DDL or DML. |