Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

drop nested table

48097Oct 26 2001
CREATE TABLE test (
id VARCHAR2(20),
Cert_refs cert_ref_list)
NESTED TABLE Cert_refs STORE AS Cert_refs_tab;

1) After droping the table test, the object "Cert_refs_tab" has
not been deleted. How can I drop it ?

2) Is it possible to drop a nested table column ?

Thank you.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 24 2001
Added on Oct 26 2001
1 comment
528 views