%Type is used to change the size of any datatype but only for one record

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

Question Posted / suresh somayajula

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

%Type is used to change the size of any datatype but only
for one record.

%Rowtype is used to declare a recoed that represents a
particular row of a table.

Is This Answer Correct ?

9 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is sap sql?

971

What is sqlservr exe?

973

when MSQL8.0 is in market

2067

What makes a good primary key?

1025

Can there be 2 primary keys in a table?

993

How can a function retun more than one value in oracle with proper example?

1065

What is integrity in sql?

1031

what is 'mysqlimport'? : Sql dba

1034

How do I run sql?

1161

Is not equal in sql?

1005

Can we use join in subquery?

1079

how to use 'mysql' to run sql statements? : Sql dba

1040

what are the types of subquery? : Sql dba

1096

What is sql scripting?

1103

What is a primary key called that is made up of more than one field?

1339