Interested to Buy Any Domain ? << Click Here >> for more details...
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 create id with auto_increment on oracle?
What is the usage of synonyms?
How to update values in a table in oracle?
How to export your own schema?
How to resolve name conflicts between variables and columns?
In the oracle version 9.3.0.5.0, what does each number shows?
Explain the use of rows option in exp command.
How do I find my oracle client driver version?
Explain the use of file option in exp command.
How to write a left outer join with the where clause in oracle?
Explain joins in oracle?
What is the difference between online and offline backups?
How to view the data files in the current database?
How to experiment a data lock in oracle?
Explain integrity constraints?
