%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

Why is the cursor important?

1003

What is lexical units in pl sql?

1081

What are the various restrictions imposed on view in terms of dml?

936

What are inbuilt functions in sql?

1013

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

958

How many sectors are in a partition?

1048

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1135

what is data manipulation language? : Sql dba

964

Define overloaded procedure?

1032

tell me about various levels of constraint. : Sql dba

1010

What is a .db file?

948

Which are the different types of indexes in sql?

1022

Is not equal in sql?

973

how to create a table index in mysql? : Sql dba

1008

Can we use views in stored procedure?

996