%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
19473 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

Why do we create stored procedures & functions in pl/sql and how are they different?

948

how to use in conditions? : Sql dba

1013

Does sql use python?

1030

Explain what is a database?

1085

What is native sql query?

1019

How to use transactions efficiently : transact sql

1058

What is trigger in sql?

1099

Is sql a programming?

971

What is the use of pl/sql table?

1066

Explain lock escalation? : Transact sql

1197

Can a foreign key have a different name?

940

Is grant a ddl statement?

896

What is a primary key sql?

1041

What is pl sql in dbms?

949

What types of commands can be executed in sql*plus?

1109