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
What is the scope of a local variable?
What do you mean by a tablespace?
Explain how you would restore a database using RMAN to Point in Time?
What happens in oracle commit?
Explain the difference between a procedure and a function? What do you understand by those terms?
What do you mean by merge in oracle and how can we merge two tables?
What is a cursor variable?
How do you store pictures in a database?
How to start a new transaction in oracle?
What is the difference between $oracle_base and $oracle_home?
In oracle there is column command, how will you explain that?
Explain oracle’s server parameter file.
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
What is an oracle database table?
What is a trigger and what are its types in oracle?
