Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\advnc_collections.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <title>Using Collections</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T16:11:31Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Using Collections" /> <meta name="relnum" content="Release 3.2" /> <meta name="partnum" content="E11947-01" /> <link rel="copyright" href="dcommon/html/cpyr.htm" title="Copyright" type="text/html" /> <link rel="stylesheet" href="dcommon/css/blafdoc.css" title="Oracle BLAFDoc" type="text/css" /> <link rel="contents" href="toc.htm" title="Contents" type="text/html" /> <link rel="up" href="preface.htm" title="Home" type="text/html" /> <link rel="up" href="advnc.htm" title="Advanced Programming Techni..." type="text/html" /> <link rel="up" href="advnc_collections.htm" title="Using Collections" type="text/html" /> <link rel="prev" href="advnc_email.htm" title="Previous" type="text/html" /> <link rel="next" href="advnc_coll_api.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface.htm" title="Home">Home</a> > <a href="advnc.htm" title="Advanced Programming Techni...">Advanced Programming Techni...</a> > Using Collections</p> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr valign="bottom"> <td align="left"></td> <td align="center"><a href="advnc_email.htm"><img src="dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="advnc_coll_api.htm"><img src="dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BABFFJJJ" name="BABFFJJJ"></a></p> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h1><a name="HTMDB13002|collections"></a>Using <a id="sthref2185" name="sthref2185"></a><a id="sthref2186" name="sthref2186"></a>Collections</h1> <p>Collections enable you to temporarily capture one or more nonscalar values. You can use collections to store rows and columns currently in session state so they can be accessed, manipulated, or processed during a user's specific session. You can think of a collection as a bucket in which you temporarily store and name rows of information.</p> <p>The following are examples of when you might use collections:</p> <ul> <li> <p>When you are creating a data-entry wizard in which multiple rows of information first need to be collected within a logical transaction. You can use collections to temporarily store the contents of the multiple rows of information, before performing the final step in the wizard when both the physical and logical transactions are completed.</p> </li> <li> <p>When your application includes an update page on which a user updates multiple detail rows on one page. The user can make many updates, apply these updates to a collection and then call a final process to apply the changes to the database.</p> </li> <li> <p>When you are building a wizard where you are collecting an arbitrary number of attributes. At the end of the wizard, the user then performs a task that takes the information temporarily stored in the collection and applies it to the database.</p> </li> </ul> <a id="sthref2187" name="sthref2187"></a> <p class="subhead2">Topics:</p> <ul> <li> <p><a href="advnc_coll_api.htm#CIHHCGGD">About the APEX_COLLECTION API</a></p> </li> <li> <p><a href="advnc_coll_create.htm#BABGHJFD">Creating a Collection</a></p> </li> <li> <p><a href="advnc_coll_trunc.htm#BABEBBEI">Truncating a Collection</a></p> </li> <li> <p><a href="advnc_coll_access.htm#CHDGGECE">Accessing a Collection</a></p> </li> <li> <p><a href="advnc_coll_del.htm#BABGGIDG">Deleting a Collection</a></p> </li> <li> <p><a href="advnc_coll_add.htm#BABCHDBC">Adding Members to a Collection</a></p> </li> <li> <p><a href="advnc_coll_updt.htm#BABJHCFB">Updating Collection Members</a></p> </li> <li> <p><a href="advnc_coll_del_mem.htm#BABHHGJC">Deleting Collection Members</a></p> </li> <li> <p><a href="advnc_coll_status.htm#BABIAEDH">Determining Collection Status</a></p> </li> <li> <p><a href="advnc_coll_merge.htm#BABICJHH">Merging Collections</a></p> </li> <li> <p><a href="advnc_coll_mg.htm#BABBFIAA">Managing Collections</a></p> </li> <li> <p><a href="advnc_coll_clear.htm#BABHBFJA">Clearing Collection Session State</a></p> </li> </ul> <!-- Start Footer --> <div class="footer"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr> <td align="left"><span class="copyrightlogo">Copyright © 2003, 2009, Oracle and/or its affiliates. All rights reserved.</span><br /> <a href="dcommon/html/cpyr.htm"><span class="copyrightlogo">Legal Notices</span></a></td> <td align="center"><a href="advnc_email.htm"><img src="dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="advnc_coll_api.htm"><img src="dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </div> <!-- class="footer" --></div> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de