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

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

928

How to get list of all tables from a database?

1160

What is AUTH_ID and AUTH_USER in pl/sql ?

2193

What is the benefit of foreign key?

1022

how to convert character strings to dates? : Sql dba

1060

Which one is better subquery or joins?

1062

What is a crud api?

954

How many clustered indexes can be created on a table?

1075

What are different joins used in sql?

1056

What is an inner join sql?

1028

Explain dml and ddl?

996

What is sql and its types?

1187

What is nvarchar max in sql?

1015

what is timestamp in mysql? : Sql dba

1075

What are all the common sql functions?

1027