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
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
How to delete all rows a table in oracle?
What are the ways tablespaces can be managed and how do they differ?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What is oracle and what are its different editions?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
What is partitioned table in Oracle?
What are the restrictions on external table columns?
What is recovery manager in Oracle?
What is primefaces used for?
What are the different editions of oracle?
How to start your 10g xe server?
How to define a data field as not null?
what is meant by magic query
what is the scripts in data base?