Oracle Tips by Burleson
Array interface is Oracle performance enhancements
enabling programmer to bind arrays to placeholders. Thus making it
possible to fetch/insert multiple rows with a single database call.
This feature primarily saves the round trips across the network, which
is very important in the world of web and internet. This feature,
however, is primarily used to speed up large load or extract
operations which are normally not performed by web servers. Web
applications should be extremely fast and finish as quickly as
possible. Loading or fetching thousand rows at a time is not an
important feature in web applications. If this is a problem, there may
be a design problem with the application.
code depot for complete scripts
The above book excerpt is from:
Create Dynamic Web Pages with Oracle Data