What are the composite date types in oracle?
- 6 Answers
- 16860 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 |
Explain the dml?
How to create a table index in oracle?
What do you mean by cdb and pdb in oracle 12c?
What is a nvl function? How can it be used?
What privilege is needed for a user to delete rows from tables in another schema?
How to delete an existing row from a table in oracle?
What is the database name in oracle?
How to bring a tablespace online?
Which Department has MOST NUMBER of employees?
8 Answers IBM, LeadSquared, Mastek,
What is bind variable in oracle 11g?
What is transport network substrate (tns) in oracle?
How to define an oracle sub procedure?
Oracle General 
