Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
SQL Statements:
DROP SEQUENCE to ROLLBACK, 8 of 20
Use the DROP
TYPE
BODY
statement to drop the body of an object type, varray, or nested table type. When you drop a type body, the object type specification still exists, and you can re-create the type body. Prior to re-creating the body, you can still use the object type, although you cannot call the member functions.
See Also:
|
The object type body must be in your own schema, and you must have
drop_type_body::=
drop_type_body
Specify the schema containing the object type. If you omit schema, Oracle assumes the object type is in your own schema.
Specify the name of the object type body to be dropped.
Restriction: You can drop a type body only if it has no type or table dependencies.
DROP
TYPE
BODY
Example
The following statement removes object type body data_typ
(created in "Updating a Type Body Example"):
DROP TYPE BODY data_typ;
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|