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

How many sql statements are used?

965

What is the difference between unique and primary key constraints?

1010

What do you mean by query optimization?

953

Is big data nosql?

888

Define tables and fields in a database

1081

How to select 10 records from a table?

1099

What does stand for in sql?

920

Enlist some predefined exceptions?

999

Explain the the delete statements in sql?

983

what is meant by urlencode and urldocode? : Sql dba

1092

What is difference between joins and union?

1046

Why select is used in sql?

970

what is try_catch block in procedure

1659

what is auto increment? : Sql dba

966

Can we perform dml in function?

1016