2 Resources for

forall

Sponsored White Papers, Webcasts, and Downloads

Process non-consecutive array items in FORALL: Prior to Oracle 10g, the FORALL statement only accepted a consecutive range of index values for processing. Starting with Oracle 10g, the INDICES OF and VALUES OF clauses can be added to support non-consecutive processing of elements in a collection. Executing Data Manipulation Language DML statements within a...; Tags: Oracle Corp., FORALL, Databases, Bob Watkins, Programming languages, clause, Oracle Tips Newsletter, TechRepublic Inc., Statement, Oracle Application Server 10g, Application Servers, Enterprise Software, Software, Software Development, Software/Web Development, Data Management; Technical articles 2006-10-31
Handle bulk binding exceptions in PL/SQL: The downside to bulk binding in PL/SQL is that if any of the data values result in an invalid UPDATE, the entire set of iterations is rolled back. Bob Watkins explains how you can get around this issue. Bulk binding in PL/SQL is an important technique for efficient...; Tags: Oracle Corp., PL/SQL, SQL%BULK_EXCEPTIONS, Listing C, Databases, Bob Watkins, Programming languages, FORALL, SAVE EXCEPTIONS, Oracle Tips Newsletter, Downside, UPDATE, Listing D, Software Development, Software/Web Development, Enterprise Software, Software, Data Management; Technical articles 2006-08-21

vpn configuraion: I am having configuring von c0onnectivity using cisco 3600 outer and pix 501it is ok forall application buit not working on remote desk to; Tags: VPNs, Network security, kidane2020@..., VPN; Discussion threads 2007-04-05
Oracle Collections: A Definition in Plain English Part 3: In part 1 of this series I covered Associative Arrays and Record types. In Part 2, I covered Varrays and Nested Tables. Today I will be covering Sparse Arrays, Bulk Collect and the FORALL command....This post originally appeared on an external website; Tags: Oracle Corp.; Blog posts 2005-10-11
Oracle Tip: Use the correct looping control in PL/SQL: This article originally appeared in the Oracle e-newsletter. Click here to subscribe automatically. When you process an index-by table in PL/SQL,there are times when you cannot be sure of the indices that existon the table, so you can't use the most obvious form of the FORloop to loop through values....; Tags: Programming languages, Databases, Scott Stephens, PL/SQL, Oracle Corp.; Technical articles 2004-05-24

Choose a method for passing arrays to the Oracle Provider for OLEDB: If you're looking for a way to pass an array of values to a PL/SQL stored procedure, you must use a technique to wrap an array into the proper PL/SQL structure on the server at runtime. Scott Stephens provides you with the necessary code. The Oracle Provider for OLEDB...; Tags: Oracle Corp., PL/SQL, SQL, Databases, Scott Stephens, Programming languages, Oracle Tips Newsletter, Procedure, Table, CreateObject, Software Development, Software/Web Development, Enterprise Software, Software, Data Management; Technical articles 2005-07-26

Cisco IOS Command Chart (IOS v.12+): Becoming proficient with Cisco equipment means remembering a whole new set of commands. These command charts give you a quick way to look up the needed IOS commands and switches when you need them.; Buy Now

Windows XP vs. Mac OS X: This presentation, entitled Standardizing on Windows XP Instead of MAC OS X, provides a pre-packaged option for defending Windows XP against MAC OS X. ...; Buy Now