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
Why we use bulk collect in oracle?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
What is ordinary table in oracle?
What privilege is needed for a user to query tables in another schema?
What is the relationship among database, tablespace and data file?
What is meant by an index?
Give the constructs of a package, function or a procedure.
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
How to select all columns of all rows from a table in oracle?
How a tablespace is related to data files?
How to build data dictionary view an new database?
various types of hints and their usage
Why use resource manager in Oracle?
What happens to the current transaction if the session is ended?
