Answer Posted / 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 |
Post New Answer View All Answers
How to export data to a csv file?
What is a cursor variable?
How to define an explicit cursor in oracle?
How will you differentiate between varchar & varchar2?
Why do we use bulk collect in oracle?
Difference between cartesian join and cross join?
What are the arithmetic operations?
How to create an oracle testing table?
What is the difference between pre-select and pre-query?
How can I create database in oracle?
What is the difference between translate and replace in oracle?
Where do you use decode and case statements?
Explain alias?
What is a subquery?
What is BBED in Oracle?
