Interested to Buy Any Domain ? << Click Here >> for more details...
What are the composite date types in oracle?
- 6 Answers
- 17809 Views
- HCL, I also Faced
- E-Mail Answers
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
view.
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
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 .
| 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)
Nested table
Varray
Record
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 |
How to create an oracle database manually?
How to define a variable to match a table column data type?
Is there a function to split a string in plsql?
Difference between pre-select and pre-query
what is meant by magic query
What is TNS File
How to save query output to a local file?
what is shell?
How to use "out" parameter properly?
How to retrieve data from an cursor to a record?
does the query needs a hint to access a materialized view?
what is pragma?
Oracle General 
