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 difference between hql and native sql?
what is sql in mysql? : Sql dba
What is the unique index?
How will you distinguish a global variable with a local variable in pl/sql?
what is oracle database ? : Sql dba
What is the syntax and use of the coalesce function?
What is primary key and foreign key with example?
What is full join in sql?
Explain what is sql*plus?
What is the difference between sum and count in sql?
Explain the the update statement in sql?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
Can we create table in function?
What does 0 mean in sql?
what is a database? : Sql dba