create type num_tbl is table of number / declare l_num_tbl num_tbl:= num_tbl(6,12,9,1,54,21, 11, 2);
On Tue, Mar 2, 2010 at 9:48 AM, oldyork90 <[email protected]> wrote: > I have a list of items that arrive in Excel, or text files, or even > over the phone. I need to get them into an array quick (I'm lazy) so > my script can do database things with them. > > Is there a way to get a list of things (cut/paste) into a pl/sql > varray simply? Is there some initialization construct that I haven't > seen? > > array(1) := 2 .... don't like > > > Was hoping for > > array = (1, 2, 3, 4, 5 ...); > > Or.. any other ideas? The main idea here is that I can just paste in > a list quick. If I have to do some coding, so be it. > > > thanks. > > -- > You received this message because you are subscribed to the Google > Groups "Oracle PL/SQL" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/Oracle-PLSQL?hl=en -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
