Differentiate between %type and %rowtype attribute in
Oracle PL/AQL programming ?
Answer Posted / kirankumar.vangeti
%ROWTYPE is used to declare a record with the same types as
found in the specified database table, view or cursor
%TYPE is used to declare a field with the same type as that
of a specified table's column.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
what is table? : Sql dba
What are the set operators in sql?
Which function is used to return remainder in a division operator in sql?
What is composite data type in pl sql?
How do you update a value in sql?
Why do we create stored procedures & functions in pl/sql and how are they different?
What is a sql select statement?
How run sql*plus commands that are stored in a local file?
how to enter numeric values as hex numbers? : Sql dba
What is sqlcommand?
Is vs as in pl sql?
What are different methods to trace the pl/sql code?
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
what is recursive stored procedure? : Sql dba
State some properties of relational databases?