what are %TYPE and %ROWTYPE? what is the difference?
- 7 Answers
- 47072 Views
- ICICI, Saama Tech, Sail, I also Faced
- E-Mail Answers
Answer Posted / hjhjnj
Column Type (i.e. %TYPE) is used to declare a field with the same type as that of a specified table’s column
Row type (i.e. %ROWTYPE) is used to declare a record with the same types as found in the specified database table, view or cursor
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What does the hierarchical profiler does?
Why should I use postgresql?
How do you select unique values in sql?
What is the difference between subquery and correlated query?
Which join is like an inner join?
where are cookies actually stored on the hard disk? : Sql dba
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000
explain the difference between bool, tinyint and bit. : Sql dba
How many types of sql are there?
what is a composite primary key ? : Sql dba
how are mysql timestamps seen to a user? : Sql dba
What is the file extension for sql database?
What is update query?
Explain autonomous transaction.
What is a temporal table?
