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
Why we use cross join?
How do you create a unique index?
What is a sql driver?
How many types of cursors are available in pl/sql?
How do I count rows in sql?
what is a trigger in mysql? : Sql dba
explain advantages of innodb over myisam. : Sql dba
How is sql used in oracle?
What is a loop in sql?
how to extract a unit value from a date and time? : Sql dba
what are the advantages and disadvantages of cascading style sheets? : Sql dba
What are the different types of dbmss?
Why is normalization important?
How do I delete a trigger?
what is the use of double ampersand (&&) in sql queries?