Answers were Sorted based on User's Feedback
Answer / sohini
Composite datatypes in Oracle are those which have internal
component.Date,number,character,boolean are Scaler data
types which have no internal Component.there are two types
of Composite datatype:
1.Records: they are used to store dissimpilar data as a
logical unit.E.g if employee is a record then emp
id,salary,department can be its various components which
together form the record.Records can be user defined
records or delared using %rowtype based of row of table or
2.Collections:They again have sub-types as nested
table,index by table and varrays.They are similar to arrays
which are used to store similar data in the form of arrays.
|Is This Answer Correct ?||26 Yes||4 No|
Answer / richa
In pl/sql we have two types of datatypes
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 .
|Is This Answer Correct ?||11 Yes||4 No|
Answer / rohini
Composite data type - is data type which has internal
components, such as RECORD, TABLE and VARRAY.
Composite datatypes are also known as collection.
|Is This Answer Correct ?||9 Yes||3 No|
Answer / art
Composite Data Types:
Associative array (index-by table)
Associative arrays, nested tables, and varrays are also referred to as collections.
|Is This Answer Correct ?||7 Yes||2 No|
Answer / yuva k
%type and %rowtype are two composite data types in Oracle.
|Is This Answer Correct ?||15 Yes||12 No|
Answer / satya
composite data types are similar to collection data type
these are like varray,associative array ,nested table
|Is This Answer Correct ?||4 Yes||6 No|
What are joins, explain all types of joins?
What are a query and state the different types of queries and their uses?
what is primary key and foreign key when and where have to use
What is index-organized table in Oracle?
Why does oracle 9i treat an empty string as null?
What is forall Statement ?
What is the difference between I and G in Oracle?
What do you know about normalization? Explain in detail?
how to create a new database in oracle?
9. Display the client name and order date for all orders using the JOIN . . . USING method.
How to find no of saturdays in a month using single sql ?
How to invoke the data pump import utility?