Differentiate between %type and %rowtype attribute in
Oracle PL/AQL programming ?
Answer Posted / madhuri
%type and %rowtype provides data independence,reduces
maintainance cost and allows programs to adapt as the
database changes due to new business requirements.
%rowtype is used to declare a record with the same types as
found in the specified database table,view or a cursor.
%type is used to declare a field with the same type as found
in the specified table's column.
Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
Is nosql relational?
Explain clause in sql?
What are the operators used in select statements?
What is multiple columns?
what are tables and fields? : Sql dba
Does view contain data?
how can we destroy the session, how can we unset the variable of a session? : Sql dba
how to select first 5 records from a table? : Sql dba
What is the difference among union, minus and intersect?
What is pl sql quora?
Explain correlated query work?
What are expressions?
what are the advantages of sql ? : Sql dba
How to order siblings in oracle hierarchy queries?
How do you write a subquery?