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 are the different tcl commands in sql?
What is the difference between instead of trigger and after trigger?
What is case function?
How can I see all tables in sql?
What are field types?
Can we use ddl statements in stored procedure?
Why use stored procedures?
What are the methods of filing?
Why join is faster than subquery?
Is it possible to create the following trigger: before or after update trigger for each row?
What are sql functions? Describe the different types of sql functions?
Why do we use function in pl sql?
how to enter characters as hex numbers? : Sql dba
What is the maximum number of rows in sql table?
What is pl sql commands?