what are %TYPE and %ROWTYPE? what is the difference?
Answer Posted / srikanth
%type can hold one perticular variable
%rowtype decalre total row declaration
Is This Answer Correct ? | 11 Yes | 2 No |
Post New Answer View All Answers
What is sql basics?
What is partition in sql query?
What is execute immediate?
What is data type in sql?
What are the types of optimization?
Can we join more than 2 tables in sql?
What are some predefined exceptions in pl/sql?
Explain how to use transactions efficiently : transact sql
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
how many ways to get the current time? : Sql dba
What does sql stand for?
What are the two different parts of the pl/sql packages?
How bulk collect improves performance?
How to place comments in pl/sql?
What is attribute indicator in pl sql?