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
Which are the different case manipulation functions in sql?
Can we use ddl commands in pl sql?
What are the three pl sql block types?
Explain the working of foreign key?
What is compilation error in pl sql?
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000
Explain what is table in a database?
what is an alias command? : Sql dba
What is sql rowcount?
What is the difference between cross join and natural join?
Can we use join in subquery?
what is not null constraint? : Sql dba
What are all different types of collation sensitivity?
What is gpt format?
What is clustered and nonclustered index in sql?