-
Junior Member
composite data type
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
-
Re: composite data type
In oracle
COMPOSITE DATA TYPES ARE---
1.RECORD TYPE
2.NESTED TABLE
3.VARRYING ARRAY
-
Expert Member
Re: composite data type
Composite data types are exactly like "Struct" data type in C. You can group logically related different data variable together...
-
Junior Member
Re: composite data type
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
-
Junior Member
Re: composite data type
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
-
Junior Member
Re: composite data type
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules