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
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.

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 .

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.

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

Answer / yuva k

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

Answer / satya

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

What are internal user account in oracle?

0 Answers  

Oracle

0 Answers   ABC, Genpact, HUI, 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??

0 Answers  

Do you know about aggregate functions? What is row num function? Can it be used all databases?

1 Answers   Bravura Solutions, Cap Gemini,

What is an oracle and why it is used?

0 Answers  

create one table to capture an employee details with a primary key.

1 Answers   CTS,

What is enter substitution variable in oracle?

0 Answers  

How to add a new column to an existing table in oracle?

0 Answers  

How to lock and unlock a user account in oracle?

0 Answers  

you are sorting a table using "order by"(descending) clause of a column which contains a null value...whether that row containing null value will come first or last in the output??

2 Answers   BirlaSoft,

how to get last monday of a month?

2 Answers   Multifonds,

Use of an integrity constraint is better to validate data. Explain

0 Answers