|
Vol: 48(62) No: 2 / June 2003 A Study on the Transmission of Sets of Records to the Oracle Server L. Jian Department of Computer Science and Engineering, "Politehnica" University of Timisoara, 2 V. Parvan, 300223 Timisoara, Romania, phone: (40) 256-403259, e-mail: ljian@cs.utt.ro, web: http://www.cs.utt.ro/~ljian/ Keywords: relational databases, Oracle-PL/SQL, optimising data transfer. Abstract When using the ForAll command instead of For…Loop and variables of data collection type (index Table, Varray, Nested Table) in PL/SQL , ForAll sends a part of the data collection to the SQL server, but not individual elements. In this scenario the necessary time for creating the table decreases , in case that the size of the group varies. References [1] * Oracle Corporation - PL/SQL User\'s Guide and Reference Release 8.1.6. [2] * Oracle Corporation - Oracle8i Application Developer\'s Guide – Fundamentals. [3] * Oracle Corporation - Oracle8i Application Developer\'s Guide - Advanced Queuing (AQ). [4] * Oracle Corporation - Oracle8i Supplied PL/SQL Packages Reference. [5] * Oracle Unleashed Second edition – SAMS Publishing 1997. |