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 the attributes of the cursor?

0 Answers  

What is a table index?

0 Answers  

in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit

3 Answers   Polaris,

What is BBED in Oracle?

0 Answers   MCN Solutions,

What is the Extension of Oracle Database? As extension of Access Database is .mdb

2 Answers  

I know that i can create a table without a primary key.But is there any significance for that table???? while creating an application.

6 Answers  

What is a user account in oracle?

0 Answers  

what is cartesian product?

2 Answers  

How to define a sub function?

0 Answers  

What are data pump export and import modes?

0 Answers  

How to run create database statement again?

0 Answers  

types of indexes and the rationale behind choosing a particular index for a situation.

0 Answers