What are % TYPE and % ROWTYPE ? What are the advantages of
using these over datatypes?
Answer Posted / nakul.v
%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 ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are sql commands?
What has stored procedures in sql and how we can use it?
Why is the cursor important?
How many tables can a sql database have?
how does a local variable is defined using t-sql? : Transact sql
What are the commands used in sql?
What is the difference between stored procedure and view?
What is date functions?
What is cte?
what is heap table? : Sql dba
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
What is rowid in sql?
How do you declare a user-defined exception?
Does sql require a server?
How does postgresql compare to oracle/db2/ms sql server/informix?