what are %TYPE and %ROWTYPE? what is the difference?
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
Does truncate require commit?
How do I upgrade sql?
Are sql connections encrypted?
What is nvarchar max in sql?
What are different types of indexes?
How to read xml file in oracle pl sql?
Is like operator in sql case sensitive?
What is the difference between delete and truncate statement in sql?
What is the difference between sum and count in sql?
What is the order of sql select?
What are actual parameters and formal parameters?
What is function and procedure in pl sql?
What type of database is sql?
How many types of indexes are there in sql?
Can I create table without primary key?