Skip to Main Content
Forums

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!

How to delete a table type

Mark1970Jul 1 2010 — edited Jul 1 2010
Hi,
I've defined a

type reg is table of mytable%rowtype INDEX BY BINARY_INTEGER;
reg_tab reg;

In my script I load some data on reg_tab
How can I delete the data from it? I mean I'd like to do something like delete from reg_tab; after finishing to work on reg_tab

Thanks

Edited by: Mark1970 on 1-lug-2010 3.23
This post has been answered by 766973 on Jul 1 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 29 2010
Added on Jul 1 2010
#plsql
4 comments
10,466 views