what are %TYPE and %ROWTYPE? what is the difference?
- 7 Answers
- 45858 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
How can you tell the difference between an index and a view?
Can we use pl sql in sql server?
Which join condition can be specified using on clause?
In pl/sql, what is bulk binding, and when/how would it help performance?
How to avoid using cursors?
Mention what does plv msg allows you to do?
Can we call stored procedure in function?
What is the primary use of normalization?
What is pivot in sql?
How do I sort a table in sql?
What are views in sql?
What does (+) mean in sql joins?
explain about mysql and its features. : Sql dba
What is serial sql?
