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


Please Help Members By Posting Answers For Below Questions

Does truncate require commit?

714


How do I upgrade sql?

737


Are sql connections encrypted?

747


What is nvarchar max in sql?

750


What are different types of indexes?

706






How to read xml file in oracle pl sql?

691


Is like operator in sql case sensitive?

732


What is the difference between delete and truncate statement in sql?

683


What is the difference between sum and count in sql?

720


What is the order of sql select?

763


What are actual parameters and formal parameters?

778


What is function and procedure in pl sql?

704


What type of database is sql?

774


How many types of indexes are there in sql?

718


Can I create table without primary key?

733