what are %TYPE and %ROWTYPE? what is the difference?
- 7 Answers
- 47073 Views
- ICICI, Saama Tech, Sail, I also Faced
- E-Mail Answers
Answer Posted / pavan_1981
these two are used with cursors to store the returing
result from the query.
%TYPE:a variable is declared to be of %type when we are
referring to a single specific column.when we declare a
variable to be of %type of a column,the variable datatype
becomes the datatype of that column..here it can only one
datatype that of the column.
%ROWTYPE:same as above but takes a single row at a time and
can accomidate multiple datatypes.it can store whole row at
a time containing different datatypes.
| Is This Answer Correct ? | 83 Yes | 2 No |
Post New Answer View All Answers
How to use transactions efficiently : transact sql
What is the purpose of my sql?
Why do we use joins in sql?
Is sql the best database?
What is left join example?
What is the limitation on the block size of pl/sql?
What is the difference between clustered and non-clustered index in sql?
what are the performance and scalability characteristics of mysql? : Sql dba
what is not null constraint? : Sql dba
What is offset in sql query?
Why do we use partitions in sql?
What is microsoft t sql?
Can you call pl/sql package functions from within a fast formula?
How do you use a while loop in pl sql?
What is a schema sql?
