Differentiate between %type and %rowtype attribute in
Oracle PL/AQL programming ?
- 7 Answers
- 18252 Views
- PreVator, I also Faced
- E-Mail Answers
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
What is %type in sql?
How many types of normalization are there?
What is the use of count (*) in sql?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
What is compilation error in pl sql?
What does cursor do in sql?
What is union, minus and interact commands?
What is full join in sql?
What is synonyms?
what is the different between now() and current_date()? : Sql dba
How do I send sql query results to excel?
What is composite data type in pl sql?
What is the best partition size for windows 10?
What is a table partition?
What are its different types of dbms?
