what are %TYPE and %ROWTYPE? what is the difference?
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 do you take the union of two tables in sql?
What is basic structure of pl sql?
What is the most common sql injection tool?
What is graph sql?
What is the sql query to display the current date?
How do I order by ascending in sql?
Can you join views in sql?
How do I partition a table in sql?
what is view? : Sql dba
What is error ora-01000: maximum open cursors exceeded
What is offset and limit in sql?
what are integrity rules?
How do I truncate a word?
Inline the values in PL/SQL, what does it mean.?
what is normalization? : Sql dba