Interested to Buy Any Domain ? << Click Here >> for more details...
what are %TYPE and %ROWTYPE? what is the difference?
- 7 Answers
- 48982 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
What is example of database?
What is sqlexception in java?
how to use case expression? : Sql dba
What is the difference between unique and primary key constraints?
What is partition in sql query?
Why is sharding used?
What is data manipulation language?
Can we call stored procedure in function?
What is a database event trigger?
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
Which are the different types of indexes in sql?
How do you modify a trigger?
How do I find duplicates in sql?
What are the commands used in sql?
What are basic techniques of indexing?
