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
How to use "out" parameter properly?
Why cursor variables are easier to use than cursors?
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.
Difference between pre-select and pre-query
What is a table index?
What is the sid in oracle?
How to define a cusotmer as a supplier in ORACLE R12
How would you go about verifying the network name that the local_listener is currently using?
Explain the use of online redo log files in oracle.
What do you mean by merge in oracle?
What happens if you lost a data file?
How to get execution path reports on query statements?
What are the four Oracle system processes that must always be up and running for the database to be useable?
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
Can group functions be used in the order by clause in oracle?