I defined a type like follow:
type utility_array is table of varchar2(200) index by binary_integer;
if the data like follows:
nmt(0) = 1
nmt(1) = 2
nmt(2) = 3
How can I select the data from the nmt?
If I use the statement like follow:
select count(*) from nmt;
an error was occured.
I want to do this
insert into tablename select * from nmt;
so I can insert more rows at the same sql statement.
How can I do ?