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

What is the data pump import utility?

780


What is the fastest query method to fetch data from the table?

1102


How many file formats are supported to export data?

885


How do I connect to oracle database?

748


How to use select statement to count the number of rows in oracle?

770


Can multiple cursors being opened at the same time?

812


How to turn on or off recycle bin for the session?

827


How to start your 10g xe server?

791


What is the difference between substr and instr?

723


How many data types are supported?

818


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

790


What happens if you use a wrong connect identifier?

721


What are the limitations oracle database 10g xe?

767


How to manage transaction isolation level?

760


What is oracle update statement with inner join ?

784