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 do I manually uninstall oracle client?
What do you mean by merge in oracle?
What is the string concatenation operator in oracle?
What is the usage of save points in oracle database?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What are the restrictions on external table columns?
State some uses of redo log files?
What is parameterized cursor in oracle?
Why do we use coalesce function in oracle?
Explain the truncate in oracle?
How to create an oracle database manually?
Give the various exception types.
Explain database link?
How to find out what oracle odbc drivers are installed?
Can you drop an index associated with a unique or primary key constraint?