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 a database is related to tablespaces?
what is the dual table in oracle?
Explain the use of full option in exp command.
What is sharded cluster?
How to start a new transaction in oracle?
Can I create users through internet explorer in oracle 10g?
What is a Garbage Collection? and what is full recursive Garbage collection?
Where do we use decode and case statements?
what is the difference between functional dependecy and multilevel dependency?
Explain the use of online redo log files in oracle.
How to manage transaction isolation level?
What is the difference between PFILE and SPFILE in Oracle?
How do you find current date and time in oracle?
What is an oracle recycle bin?
Why is oracle database so popular?
