Differentiate between %type and %rowtype attribute in
Oracle PL/AQL programming ?

Answer Posted / suresh somayajula

%Type is used to change the size of any datatype but only
for one record.

%Rowtype is used to declare a recoed that represents a
particular row of a table.

Is This Answer Correct ?    9 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference among union, minus and intersect?

539


How bulk collect improves performance?

566


What is primary and foreign key?

587


What is rename in sql?

544


How do I run a pl sql program?

623






What are aggregate functions in sql?

619


What is the maximum database size for sql express?

524


Is pl sql still used?

503


Why schema is used in sql?

508


When is the update_statistics command used?

566


How can I change database name in sql?

521


What is sql and also describe types of sql statements?

558


What steps server process has to take to execute an update statement?

504


What is trigger explain with example?

543


What does truncate mean in sql?

529