what are %TYPE and %ROWTYPE? what is the difference?
Answer Posted / lakshminarayana reddy
%Type:- used to variable according to column sturcture
%Rowtype:- used to variable accordin to compleat record
sturcture.
| Is This Answer Correct ? | 35 Yes | 5 No |
Post New Answer View All Answers
What is the usage of when clause in trigger?
What does closing a cursor do?
How do you rank data in sql?
What does pl sql developer do?
What does the sign mean in sql?
What problem one might face while writing log information to a data-base table in pl/sql?
What are the triggers associated with image items?
what happens if you no create privilege in a database? : Sql dba
What is date functions?
Why having clause is used in sql?
What is a record in a database?
What are the commands used in sql?
Why primary key is required?
What is materialized view in sql?
What is the benefit of foreign key?