Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

What are the composite date types in oracle?

Answers were Sorted based on User's Feedback

What are the composite date types in oracle? ..

Answer / 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
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

What are the composite date types in oracle? ..

Answer / richa

In pl/sql we have two types of datatypes
1. scalar
2. composite.

In scalar u can store only one value at a time and
ex is a number(10),name char(1) etc.

While in Composite u can store whole row mean if one row
have 3 columns so u can store 3 values in a composite
datatype variable at a time.
Ex. emp employees%rowtype ;
Mean if enployees have 3 columns so in variable emp u can
store 3 values of 3 columns at a time .

Is This Answer Correct ?    11 Yes 4 No

What are the composite date types in oracle? ..

Answer / rohini

Composite data type - is data type which has internal
components, such as RECORD, TABLE and VARRAY.
Composite datatypes are also known as collection.

Is This Answer Correct ?    9 Yes 3 No

What are the composite date types in oracle? ..

Answer / art

Composite Data Types:

Associative array (index-by table)
Nested table

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

Is This Answer Correct ?    7 Yes 2 No

What are the composite date types in oracle? ..

Answer / yuva k

%type and %rowtype are two composite data types in Oracle.

Is This Answer Correct ?    15 Yes 12 No

What are the composite date types in oracle? ..

Answer / satya

composite data types are similar to collection data type
these are like varray,associative array ,nested table

Is This Answer Correct ?    4 Yes 6 No

Post New Answer

More Oracle General Interview Questions

What are joins, explain all types of joins?

0 Answers   Bravura Solutions,

What are a query and state the different types of queries and their uses?

0 Answers  

what is primary key and foreign key when and where have to use

5 Answers  

What is index-organized table in Oracle?

0 Answers   MCN Solutions,

Why does oracle 9i treat an empty string as null?

0 Answers  

What is forall Statement ?

2 Answers   Thermotech,

What is the difference between I and G in Oracle?

0 Answers   MCN Solutions,

What do you know about normalization? Explain in detail?

0 Answers  

how to create a new database in oracle?

6 Answers   TCS,

9. Display the client name and order date for all orders using the JOIN . . . USING method.

2 Answers   Wipro,

How to find no of saturdays in a month using single sql ?

2 Answers  

How to invoke the data pump import utility?

0 Answers  

  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (509)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)