ROWTYPE is declared at the record level and the TYPE is declared for the

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

Question Posted / sunil

Answer Posted / sunil

ROWTYPE is declared at the record level and the TYPE is
declared for the coloumn level.

Is This Answer Correct ?

8 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do I install sql?

696

Why do we need cursor in pl sql?

832

What is bitemporal narrowing?

999

Is it possible to include an insert statement on the same table to which the trigger is assigned?

731

what is the difference between primary key and unique key? : Sql dba

704

Explain the working of foreign key?

723

What is #table in sql?

704

Define select, insert, create, delete, update, drop keywords

776

What is normalization in sql?

717

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

728

Why is sql*loader direct path so fast?

797

What is the difference between microsoft sql and mysql?

709

What is error ora-01000: maximum open cursors exceeded

783

What is a delimiter in sas?

730

what is a composite key ? : Sql dba

796