Interested to Buy Any Domain ? << Click Here >> for more details...
Differentiate between %type and %rowtype attribute in
Oracle PL/AQL programming ?
- 7 Answers
- 19204 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 are hotfixes and patches?
Can I create table without primary key?
How to select unique records from a table?
What is a primary key? Explain
What is a temporal data type?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
What is auto increment feature in sql?
What is a Mapplet?
What are inner and outer joins examples of both?
how can we repair a mysql table? : Sql dba
how to use regular expression in pattern match conditions? : Sql dba
What is procedure explain with program?
What is difference between group by and partition by?
how would concatenate strings in mysql? : Sql dba
How can get second highest salary in sql?
