Composite Variables

What are Composite Variable?

Questions by kantri   answers by kantri

Showing Answers 1 - 9 of 9 Answers

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

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions