Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2296


How to delete all rows a table in oracle?

1056


What are the ways tablespaces can be managed and how do they differ?

2341


You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

1986


What is oracle and what are its different editions?

1054


what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2258


What is partitioned table in Oracle?

1168


What are the restrictions on external table columns?

1039


What is recovery manager in Oracle?

1036


What is primefaces used for?

1036


What are the different editions of oracle?

1090


How to start your 10g xe server?

1018


How to define a data field as not null?

1092


what is meant by magic query

2160


what is the scripts in data base?

2126