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
What is the data pump import utility?
What is the fastest query method to fetch data from the table?
How many file formats are supported to export data?
How do I connect to oracle database?
How to use select statement to count the number of rows in oracle?
Can multiple cursors being opened at the same time?
How to turn on or off recycle bin for the session?
How to start your 10g xe server?
What is the difference between substr and instr?
How many data types are supported?
When do we use group by clause in a sql query?
What happens if you use a wrong connect identifier?
What are the limitations oracle database 10g xe?
How to manage transaction isolation level?
What is oracle update statement with inner join ?