%row type is used to focus on particular record. row%type is used to focus

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

Question Posted / savani rakshit

Answer Posted / savani rakshit

%row type is used to focus on particular record.
row%type is used to focus on single row

Is This Answer Correct ?

6 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Does postgresql run on the cloud?

1135

What is sql architecture?

1041

Can a foreign key be a duplicate?

903

How do you use join?

930

how to write date and time literals? : Sql dba

953

How do I quit sql?

943

what is the difference between $message and $$message? : Sql dba

991

what is timestamp in mysql? : Sql dba

1064

When is a declare statement required?

1133

Does mysql support pl sql?

1151

What is field delimiter?

1040

Are stored procedures faster than queries?

940

what is the difference between char_length and length? : Sql dba

1036

What is mutating error in pl sql?

1009

What is a recursive join sql?

1059