| Publisher | Oracle | ||
|---|---|---|---|
| Format | HTML | Date added | 13 Oct 2006 |
| Topics | Database Management, Database Applications | ||
| Downloads | 1 | ||
Many PL/SQL programs manipulate data, often by using SQL to work with that data directly in the database. Yet a person often needs to declare and manage data within PL/SQL programs themselves. This program data might consist of individual values (scalars). In many other situations, however, one may deal with much more complex data structures, from records to objects (instances of object types) to lists. Lists (and, in their more complex manifestation, arrays) are crucial elements in a programmer's toolbox. To create and manage these lists, PL/SQL offers a variety of structures - called collections: nested tables, varying arrays, and associative arrays. Associative arrays were introduced in Oracle9i Release 2 to replace index-by tables (which replaced PL/SQL tables in Oracle8).
Did you find this white paper useful?
18 out of 38 users found this white paper useful
Related white papers
The Evolution of Integration
Once upon a time life and information systems were simple. Then one day somebody let Pandora out of her box. Someone said -can't we add new requirements to these systems?...
The Role of Open Source Data Integration
This free-to-download whitepaper looks at how Enterprise customers are demanding project]sized data integration tools that can be scaled up to enterprise use. They donft want complex, expensive DI products that...
Creating a Dynamic Infrastructure through Virtualization
In almost every case,the transformation to a dynamic infrastructure will involve virtualization.Many IT professionals think of virtualization specifically in terms of servers.IBM,however,has a broader perspective,in which virtualization is seen as...
Dynamic Infrastructure Helping Build a Smarter PlanetDelivering Superior Business and IT Services with Agility and Speed
In this smarter world, we need our infrastructure to propel us forward, not hold us back. This infrastructure becomes instrumented, interconnected and intelligent to bring together the business and IT...
IBM Virtualization Services
Virtualization is a powerful technology and can have profound effects on the datacenter; however, it should be viewed as a component of an overall IT strategy that will be able...
MSC Industrial Direct- customer case study
"Following a company merger, MSC Industrial Direct Co. found that duplicate customer records were disrupting the business workflow and causing sales compensation issues. MSC Industrial Direct Co. implemented the Pitney Bowes Business...
Customer Data Quality Platform from Pitney Bowes Business Insight - a Butler Group Technology Audit report
Pitney Bowes Customer Data Quality Platform (CDQP) is a domain-specific customer data quality management system that enables tasks such as integration, cleansing, matching, profiling, monitoring, and enriching the data with...
