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 pl sql block structure?

545


Do foreign keys improve performance?

549


How do you add a column to a table?

604


What is flag in sql?

545


How do I delete a trigger?

545






What is the difference between an inner join and an outer join?

516


What is the use of double ampersand (&&) in sql queries? Give an example

613


Cite the differences between execution of triggers and stored procedures?

624


What is the use of stored procedures?

519


What is union and union all keyword in sql and what are their differences?

579


How can I change database name in sql?

533


What is rownum?

542


what are all the different types of indexes? : Sql dba

533


What are all the different normalization?

562


Can we use having without group by in sql?

555