Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL Records/Tables

Re: PL/SQL Records/Tables

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 27 Mar 2006 11:34:12 -0800
Message-ID: <1143488045.206341@yasure.drizzle.com>


Dereck L. Dietz wrote:
> I know in Oracle forms there is a way to keep information in a memory table
> through record structures that you can then traverse record by record.
>
> Is that an Oracle form-specific ability or can that also be done in an
> Oracle PL/SQL procedure? If it can be done, then how would a record be
> written into memory by the procedure?
>
> Thanks.

It can be done in PL/SQL too using any one of a wide variety of array types. For example go to Morgan's Library at www.psoug.org and look at "Associative Arrays."

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Mon Mar 27 2006 - 13:34:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US