Interested to Buy Any Domain ? << Click Here >> for more details...
What are the composite date types in oracle?
- 6 Answers
- 18022 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 26 Yes | 4 No |
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 |
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 |
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.
| Is This Answer Correct ? | 7 Yes | 2 No |
Answer / yuva k
%type and %rowtype are two composite data types in Oracle.
| Is This Answer Correct ? | 15 Yes | 12 No |
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 |
What is clusters ?
Can a property clause itself be based on a property clause ?
How can return max date row A b c d e 1 2 1-mar-09 5 10 1 2 10-mar-09 5 10 Only using oracle predefined function. Not user defined. Output:-- A b c d e 1 2 10-mar-09 5 10
What do you know about normalization? Explain in detail?
How to find out what privileges a user currently has in oracle?
What is raw datatype in oracle?
How do I know if oracle is installed on windows?
Why is oracle database so popular?
how to store only time in a data base table
What is an oracle cursor variable?
How many types of database triggers exist?
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??
Oracle General 
