Interested to Buy Any Domain ? << Click Here >> for more details...
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
IS it possible to built the oracle database without setting the kernal parameters?
Is oracle a language?
What is null value in oracle?
How to speed up webrick?
What is the difference between truncate & delete command?
How to drop a stored procedure in oracle?
What is the relation of a user account and a schema?
How to find the duplicate rows count from employees table in oracle?
What do you mean by redo log file mirroring?
What is a sub query and what are the different types of subqueries?
What is the difference between PFILE and SPFILE in Oracle?
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
Give the different types of rollback segments.
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
