%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 is the purpose of the partition table?

1049

What is denormalization in a database?

1053

What is scalar and vector?

1004

What is left join example?

949

What is optimistic concurrency control? : Transact sql

984

What is sql clause?

1051

What is rowid in sql?

986

What are the dml statements?

1143

What is benefit of creating memory optimized table?

972

What are the benefits of pl sql?

1121

What are the two types of exceptions in pl/sql?

1052

what is oracle database ? : Sql dba

1029

What are the types of optimization?

961

How is data stored in sql?

1061

What are the parts of a basic sql query?

967