what are %TYPE and %ROWTYPE? what is the difference?
- 7 Answers
- 45848 Views
- ICICI, Saama Tech, Sail, I also Faced
- E-Mail Answers
Answer Posted / vikneswaran
%type is used to declare variable for one column in the table
%type is used to declare variable for entire table
| Is This Answer Correct ? | 7 Yes | 14 No |
Post New Answer View All Answers
What is orm in sql?
How can triggers be used for the table auditing?
How can you load multi line records? : aql loader
what is the difference between char and varchar data types? : Sql dba
Is sql a oracle?
what is 'trigger' in sql? : Sql dba
Where is pl sql used?
What is sql dialect?
What are analytic functions in sql?
Explain what is a database?
explain the difference between bool, tinyint and bit. : Sql dba
What are all the different normalization?
What is difference between group by and partition by?
Does asenumerable execute the query?
Mention what are different methods to trace the pl/sql code?
