%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

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1045

How to pipe multiline string to isql?

959

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1092

what are all the different normalizations? : Sql dba

960

What is the difference between truncate and drop statements?

1084

How many types of functions are there in sql?

897

how to use in conditions? : Sql dba

958

differentiate between float and double. : Sql dba

989

How do you update sql?

912

What is sap sql anywhere?

972

What is a natural join sql?

920

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

1036

Explain the difference between rename and alias?

965

what are different types of collation sensitivity? : Sql dba

1022

What is error ora-01000: maximum open cursors exceeded

1061