Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to assign values to a table of Record Type
Hi,
I need to assign the tab1 variable as
ABC, 101
XYZ, 202
type rec is record (nm varchar2(10),id number);
type tab is table of rec;
tab1 tab;
Is it possible something like
tab1 tab:= tab(rec('ABC',101),rec('XYZ',202)).
I tried above syntax but got compilation error.
Pls suggest , is there a way to do so. Received on Wed Nov 29 2006 - 04:42:45 CST