what are %TYPE and %ROWTYPE? what is the difference?
Answer Posted / vikneswaran
%type is used to declare variable for one column in the table
%type is used to declare variable for entire table
Is This Answer Correct ? | 7 Yes | 14 No |
Post New Answer View All Answers
What are stuff and replace function?
What are the different types of triggers?
Can you call pl/sql package functions from within a fast formula?
How many commands are there in sql?
Why do we use subquery?
What is a crud api?
What is optimistic concurrency control? : Transact sql
What is a primary key sql?
What is the difference between a primary key and a clustered index?
how can we know the number of days between two given dates using mysql? : Sql dba
What is cross join example?
What are database links used for?
Does inner join remove duplicates?
Can we use two order by clause in query?
How to convert comma separated string to array in pl/sql?