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 purpose of a sql?
What is sql lookup?
What problem one might face while writing log information to a data-base table in pl/sql?
What is sqlservr exe?
Mention what are the benefits of pl/sql packages?
What is the main reason behind using an index?
How do I turn a list into a table?
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
what is bcp? When does it used? : Sql dba
Describe different types of general function used in sql?
How do I find duplicates in the same column?
What is coalesce sql?
What are the advantages of normalization?
What are commit, rollback, and savepoint?
Can you do multiple joins in sql?