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
What happens if the imported table already exists?
What is the difference between a primary key & a unique key?
How to create a single index for multiple columns?
What is a lookup table in oracle?
Explain oracle left join with an example?
How to assign query results to variables?
How to rename a column in an existing table?
How can we find out the duplicate values in an oracle table?
How can you use check constraints for self referential integrity?
How to convert a date to char in oracle? Give one example.
What is the parameter mode that can be passed to a procedure?
How to define a record variable to store a table row?
Difference between open_form and call_form in oracle.
Can we call procedure inside function in oracle?
what is the difference between data migration and production migration.
