dear friends,
i want to know the details composite data type .
what is composite data type ?
how many types of composite data types is there ?.
and where it is required ?
plz if u can then with examples ..
thaks and regrds ...
from
sam
Printable View
dear friends,
i want to know the details composite data type .
what is composite data type ?
how many types of composite data types is there ?.
and where it is required ?
plz if u can then with examples ..
thaks and regrds ...
from
sam
In oracle
COMPOSITE DATA TYPES ARE---
1.RECORD TYPE
2.NESTED TABLE
3.VARRYING ARRAY
Composite data types are exactly like "Struct" data type in C. You can group logically related different data variable together...
collections are called as composite datatypes like varray,record,nested tables.
examples u can write on ur own by using all the above.
syntax :
type typename is record(.....)
type typename is table of(..) index by binary_integer
There are 2 types mainly used
RECORD TYPE:-stores single row
INDEX BY:-can hav multiple rows and column
We use it to handle more than one values at a time
THESE ARE USED MAINLY IN PL/SQL :)
Hi,
in pl/sql we have two types of datatypes
1. scalar
2. composite.
In scalar u can store only one value at a time and
ex is a number(10),name char(1) etc.
WHile in Composite u can store whole row mean if one row have 3 columns so u can store 3 values in a composite datatype variable at a time.
Ex. emp employees%rowtype ;
Mean if enployees have 3 columns so in variable emp u can store 3 values of 3 columns at a time .
Hope u Got :).
Bye.