Interested to Buy Any Domain ? << Click Here >> for more details...
What are % TYPE and % ROWTYPE ? What are the advantages of
using these over datatypes?
- 4 Answers
- 12803 Views
- I also Faced
- E-Mail Answers
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 are enums used for in mysql? : Sql dba
What is anonymous block in sql?
What is cursor in pl sql?
Explain the order of sql statement execution?
What is sql basics?
What does the hierarchical profiler does?
What are local and global Indexes and where they are useful.
i have some prob lem to tell me about my self in interview first round ...
define sql insert statement ? : Sql dba
explain what is mysql? : Sql dba
How do I make my sql query run faster?
What is auto increment feature in sql?
What are sql procedures?
Explain the purpose of %type and %rowtype data types with the example?
What is the difference between clustered and non-clustered indexes?
