%Type:- used to variable according to column sturcture %Rowtype:- used to

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

Question Posted / lakshminarayana reddy

Answer Posted / lakshminarayana reddy

%Type:- used to variable according to column sturcture
%Rowtype:- used to variable accordin to compleat record
sturcture.

Is This Answer Correct ?

35 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What found sql?

994

how to include comments in sql statements? : Sql dba

999

Show how functions and procedures are called in a pl/sql block.

1181

How do I view a sql trace file?

1061

What is sql*loader?

1283

What are tables in sql?

1115

How does postgresql compare to oracle/db2/ms sql server/informix?

1092

What is %rowtype in pl sql?

1029

Why is a trigger used?

990

What are the sql aggregate functions?

1182

What is a dynamic query?

1069

what is the use of set statement in tsql? : Transact sql

1059

Which is faster count (*) or count 1?

1088

Do foreign keys improve performance?

1068

What is string data type in sql?

1213