chaitra murthy

 Profile Answers by chaitra murthy 

• Jan 9th, 2009

 

I assume that it should be composite data type not composite variables.
Well there are two types of data types in Oracle PlSQL.

Primitive datatyes: are simple datatypes which help to store simple data like integer, number, char, date etc
Ex: number, varchar, date etc

Composite datatypes: is the group of  various data types
Ex: Cursors, Record, Tables etc

agitatedsoul10

 Profile Answers by agitatedsoul10 

• Aug 4th, 2010

 

A Variable holds a value in a memory location. The Association of a variable to other variables can be called as composite variables.

Rams

• Aug 6th, 2011

 

A composite variable has internal components, which you can access individually. You can pass entire composite variables to subprograms as parameters. PL/SQL has two kinds of composite variables, collections and records.

In a collection, the internal components are always of the same data type, and are called elements. You access each element by its unique index. Lists and arrays are classic examples of collections.

In a record, the internal components can be of different data types, and are called fields. You access each field by its name. A record variable can hold a table row, or some columns from a table row.