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
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
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: after delete trigger
Next Topic: Connect by help 2
Goto Forum:

Current Time: Wed Aug 23 03:10:52 CDT 2017

Total time taken to generate the page: 0.06468 seconds