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 / swapna

Answer Posted / swapna

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

Is This Answer Correct ?

24 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Explain exception handling in pl/sql?

1039

What are views in sql?

993

Is json a nosql?

984

Why we use pl sql?

963

how to shutdown mysql server? : Sql dba

1107

Does a primary key have to be a number?

965

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1119

what is table? : Sql dba

1068

What are the various restrictions imposed on view in terms of dml?

967

What are the different ways to optimize a sql query?

949

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

975

How do I run sql?

1192

Which query operators in sql is used for pattern matching?

969

Explain the purpose of %type and %rowtype data types with the example?

996

Show code of a cursor for loop.

1057