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 pl sql block structure?
Do foreign keys improve performance?
How do you add a column to a table?
What is flag in sql?
How do I delete a trigger?
What is the difference between an inner join and an outer join?
What is the use of double ampersand (&&) in sql queries? Give an example
Cite the differences between execution of triggers and stored procedures?
What is the use of stored procedures?
What is union and union all keyword in sql and what are their differences?
How can I change database name in sql?
What is rownum?
what are all the different types of indexes? : Sql dba
What are all the different normalization?
Can we use having without group by in sql?