what are %TYPE and %ROWTYPE? what is the difference?
Answer Posted / hjhjnj
Column Type (i.e. %TYPE) is used to declare a field with the same type as that of a specified table’s column
Row type (i.e. %ROWTYPE) is used to declare a record with the same types as found in the specified database table, view or cursor
Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What is foreign key and example?
What is function and procedure in pl sql?
What are reports usually used for?
What is sqlite format?
What is sql partition function?
Can I create table without primary key?
What is trigger in pl sql?
What is a common use of group by in sql?
Mention what does the hierarchical profiler does?
Why is %isopen always false for an implicit cursor?
Why functions are used in sql?
what is user defined functions? : Sql dba
What is sql trigger example?
what is uncommittable transactions? : Transact sql
What do you understand by case manipulation functions?