Friday, 21 April 2017

Collection Types in Object database systems

Collection types in object relational database systems, Collection types VARRAY, Nested Tables, and Associative Arrays in Oracle


Collection Types

A collection is an ordered group of elements of same type. The purpose of collection type is to support multiple values for one attribute [variable]. For example, other programming languages support the collection types array, lists, sets, bags, trees etc. To extend these features in database applications, PL/SQL provides the following collection types;


  • Associative Arrays

***************


No comments:

Post a Comment

SQL exercises for beginners one

SQL Exercises for Beginners / Simple SQL Exercises with Answers / Solved SQL exercises / SQL solved exercises with simple conditions / So...