Interested to Buy Any Domain ? << Click Here >> for more details...
what are %TYPE and %ROWTYPE? what is the difference?
- 7 Answers
- 49254 Views
- ICICI, Saama Tech, Sail, I also Faced
- E-Mail Answers
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 the life of an sql statement?
Can we use update in sql function?
what is view? : Sql dba
What will you get by the cursor attribute sql%notfound?
How do you take the union of two tables in sql?
Why is sql*loader direct path so fast?
What is meant by cursor in sql?
What is benefit of creating memory optimized table?
what is denormalization. : Sql dba
How to display Row Number with Records in Oracle SQL Plus?
What are the different types of tables in sql?
Is coalesce faster than isnull?
What is sqlerrd?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
what are tables and fields? : Sql dba
