What are the composite date types in oracle?

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


Please Help Members By Posting Answers For Below Questions

State some uses of redo log files?

785


How to create additional tablespaces for an new database?

810


query optmization techniques and quwry analyser+projects+ppts

2178


What do you mean by group by clause?

801


When do we use group by clause in a sql query?

819


What is the sid in oracle?

726


What is set operator oracle?

739


Does oracle database need java?

768


What is a read write transaction in oracle?

841


How to start instance with a minimal initialization parameter file?

808


How do we get field details of a table?

753


Difference between the “verify” and “feedback” command?

1093


How do you tell what your machine name is and what is its IP address?

1775


how to handle exceptions in post production

1189


What are the various constraints used in oracle?

809