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
- 12804 Views
- I also Faced
- E-Mail Answers
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
How to pronounce postgresql?
What is online transaction processing (oltp)?
How do I delete a trigger?
Why query optimization is needed?
what is difference between delete and truncate commands? : Sql dba
What is user in sql?
Is inner join faster than left join?
How to handle bulk data?
What does bitemporal mean?
What language is oracle sql developer?
What is the largest value that can be stored in a byte data field?
How many types of normalization are there?
what are the types of subquery? : Sql dba
What is the difference between python and sql?
Can I create table without primary key?
