%type can hold one perticular variable %rowtype decalre total row declarat

what are %TYPE and %ROWTYPE? what is the difference?

Question Posted / srikanth

Answer Posted / srikanth

%type can hold one perticular variable
%rowtype decalre total row declaration

Is This Answer Correct ?

11 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is the requirement of self-join?

1026

What are tuples in sql?

1062

Which language is used in sql?

990

What are two statement types in sql?

1031

How many times can we commit in a loop?

956

Can we connect to postgresql using sql developer?

935

What is orm in sql?

993

Explain what is sql*plus?

1085

What are views in sql?

926

How many sectors are in a partition?

1032

What is the difference between jpql and sql?

1022

Why do we use function in pl sql?

1006

What is sql table?

903

Is it possible to read/write files to-and-from PL/SQL?

1036

Are views faster than queries?

917