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 sql indexing?

750


What is pl sql architecture?

680


Define commit?

742


How to take user input in pl sql?

887


Can we use the cursor's to create the collection in PL/SQL?

694






What are the advantages of stored procedure?

721


What is a native sql query?

699


what is innodb? : Sql dba

760


What are the 3 types of behavioral triggers?

940


What is meant by truncate in sql?

748


How can you select unique records from a table?

699


What is mutating error?

696


Can we insert data into materialized view?

708


Does execute immediate commit?

925


How many databases can sql express handle?

729