Home » SQL & PL/SQL » SQL & PL/SQL » put a result into an array
put a result into an array [message #213035] Tue, 09 January 2007 03:34 Go to next message
emadbsb
Messages: 334
Registered: May 2005
Location: egypt
Senior Member

Hii all

can i put a result of a query into an array
	select so.ponumber INTO so_pono
  from ssoivdtxx,ssoxxxxxx so
   where SSODT_SSO_NO = no
     and SIVDT_GIV_NO = :p_giv_no
     and SSODT_SSO_NO = :so_no
   order by SSODT_SSO_NO;


i want so_pono to be an array to hold the results from
this query


Thanks for everyone helped and helping me

Re: put a result into an array [message #213037 is a reply to message #213035] Tue, 09 January 2007 03:38 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
You need to look at the BULK COLLECT syntax.

Documentation - it's a wonderful thing.
Previous Topic: Select Command doubt
Next Topic: after delete trigger
Goto Forum:
  


Current Time: Thu Dec 08 06:02:00 CST 2016

Total time taken to generate the page: 0.33314 seconds