What are the composite date types in oracle?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to use "out" parameter properly?

604


Why cursor variables are easier to use than cursors?

547


I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

1676


Difference between pre-select and pre-query

550


What is a table index?

542






What is the sid in oracle?

511


How to define a cusotmer as a supplier in ORACLE R12

1700


How would you go about verifying the network name that the local_listener is currently using?

1581


Explain the use of online redo log files in oracle.

554


What do you mean by merge in oracle?

569


What happens if you lost a data file?

551


How to get execution path reports on query statements?

538


What are the four Oracle system processes that must always be up and running for the database to be useable?

569


normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

1718


Can group functions be used in the order by clause in oracle?

554