%ROWTYPE is used to declare a record with the same types as found in the

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

Question Posted / kirankumar.vangeti

7 Answers
19191 Views
PreVator, I also Faced
E-Mail Answers

Answer Posted / kirankumar.vangeti

%ROWTYPE is used to declare a record with the same types as
found in the specified database table, view or cursor

%TYPE is used to declare a field with the same type as that
of a specified table's column.

Is This Answer Correct ?

4 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is sql an operating system?

959

Explain the working of primary key?

1033

How does sql developer connect to oracle database?

949

How can check sql version from command line?

1007

How subquery works in sql?

993

What is implicit cursor in pl sql?

1024

how to check myisam tables for errors? : Sql dba

1256

what is commit? : Sql dba

1025

what is oracle database ? : Sql dba

966

Is stored procedure faster than query?

913

What is group function in sql?

961

what are the 'mysql' command line options? : Sql dba

1014

Is left join inner or outer by default?

972

What is use of package in pl sql?

948

What is trigger in flip flop?

956