what are %TYPE and %ROWTYPE? what is the difference?

Answer Posted / srikanth

%type can hold one perticular variable
%rowtype decalre total row declaration

Is This Answer Correct ?    11 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sql basics?

571


What is partition in sql query?

508


What is execute immediate?

542


What is data type in sql?

550


What are the types of optimization?

515






Can we join more than 2 tables in sql?

483


What are some predefined exceptions in pl/sql?

544


Explain how to use transactions efficiently : transact sql

523


what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

563


how many ways to get the current time? : Sql dba

521


What does sql stand for?

537


What are the two different parts of the pl/sql packages?

555


How bulk collect improves performance?

566


How to place comments in pl/sql?

599


What is attribute indicator in pl sql?

516