What are % TYPE and % ROWTYPE ? What are the advantages of
using these over datatypes?
Answer Posted / nishi
%TYPE provides the data type of a variable or a database column to that variable.
%ROWTYPE provides the record type that represents a entire row of a table or view or columns selected in the cursor.
The advantages are :
I. Need not know about variable's data type.
II.If the database definition of a column in a table changes, the data type of a variable changes accordingly.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is 'mysqlcheck'? : Sql dba
Does sql use python?
What is using in sql?
how to increment dates by 1 in mysql? : Sql dba
How do rank () and dense_rank () differ?
What are the main features of cursor?
What is a table?
What sql database should I use?
Which operator is used in query for pattern matching?
Difference between global and parameter variables?
what is a constraint? : Sql dba
Can we use threading in pl/sql?
Define join and name different types of joins?
What are different types of functions in sql?
Can we use insert statement in function?