What are the composite date types in oracle?

Answer Posted / art

Composite Data Types:

Associative array (index-by table)
Nested table
Varray
Record

Associative arrays, nested tables, and varrays are also referred to as collections.

Is This Answer Correct ?    7 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to call a stored function in oracle?

565


Explain what does a control file contain?

600


What are the types of trigger in oracle?

566


How to rollback the current transaction in oracle?

532


how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

1520






Explain the types of exception?

641


Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

1764


Can you drop an index associated with a unique or primary key constraint?

573


Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

1857


What is hash cluster in oracle?

588


How to start instance with a minimal initialization parameter file?

521


How to check the server version in oracle?

604


What is Library Cache in Oracle?

633


Explain the use of record length option in exp command.

546


What is a nvl function?

555