composite data type [message #648583] |
Thu, 25 February 2016 16:55 |
|
M123
Messages: 47 Registered: February 2016 Location: USA
|
Member |
|
|
hi all
I want to know when we have to use or on what basis we have to use composite data type
Records,Varrays,index - i mean on what basis we can come to conclusion that if we use this datatype in our program we can achieve result..
if we use varray(10) ..we are limiting the values to be processed...
I worked on few basic examples for records and varraay ,,But could not understand clearly we have to use them ?
Any comment is appreciated.
[Updated on: Thu, 25 February 2016 17:21] Report message to a moderator
|
|
|
|
|
|
|
|
|
Re: composite data type [message #648593 is a reply to message #648583] |
Fri, 26 February 2016 01:11 |
|
Michel Cadot
Messages: 68624 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
This is explained in the book I already pointed you:
Database PL/SQL Language Reference
In chapter 5 "PL/SQL Collections and Records", you have sections like:
- Appropriate Uses for Associative Arrays
- Appropriate Uses for Varrays
- Appropriate Uses for Nested Tables
- ...
So once more, read this book.
Also ALWAYS post your Oracle version with your questions.
|
|
|