Interested to Buy Any Domain ? << Click Here >> for more details...
what are %TYPE and %ROWTYPE? what is the difference?
- 7 Answers
- 48688 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 do you optimize a query?
How do I run a sql script?
What is the difference between inner join and left join?
What is trigger in sql and its types?
What is the syntax and use of the coalesce function?
What is offset in sql query?
What is cte sql?
what are all the different normalizations? : Sql dba
What is sql dialect?
How many types of cursors are available in pl/sql?
What are different methods to trace the pl/sql code?
What is indexing oracle sql?
What is substitution variable in pl sql?
What is duration in sql profiler trace?
Is subquery faster than join?
