Interested to Buy Any Domain ? << Click Here >> for more details...
what are %TYPE and %ROWTYPE? what is the difference?
- 7 Answers
- 48692 Views
- ICICI, Saama Tech, Sail, I also Faced
- E-Mail Answers
Answer Posted / p.rajasekar
%RowType
1.%ROWTYPE is used to declare a record with the same types
as found in the specified database table, view or cursor.
Example:
DECLARE
v_EmpRecord emp%ROWTYPE;
2.Whenever we change the datatype in database,No need to
change in Application code using the %RowType, because
It will automatically take care of the dtatype change
%Type
1.%TYPE is used to declare a field with the same type as
that of a specified table's column. Example:
DECLARE
v_EmpNo emp.empno%TYPE;
2.Whenever we change the datatype in database,No need to
change in Application code using the %RowType, because
It will automatically take care of the dtatype change
| Is This Answer Correct ? | 25 Yes | 5 No |
Post New Answer View All Answers
What is the difference between syntax error and runtime error?
Why is the cursor important?
What are the types pl/sql code blocks?
What are triggers and its uses?
What is trigger in sql?
Is pl sql different from sql?
Who developed sql?
How do you sort in sql?
define data blocks ? : Sql dba
What is a data definition language?
What are sql data types?
What is meant by cursor in sql?
Can a view be mutating? If yes, then how?
How many joins can you have in sql?
What is sql injection vulnerability?
