Explain what Is The Advantage Of Using The %rowtype Datatype?

Question

1 Answer

Robindeniel · Answer 1 · 2021-03-11T06:03:43+0000

The advantages of using the %ROWTYPE datatype to declare variables are given as follows:

It is useful to retrieve an entire row from a table. If you do not use the %ROWTYPE datatype, then you have to declare variables for each column separately.
It can be used even if datatype of the table columns is not known
It ensures that datatype of the variable changes dynamically if the underlying table is altered.