Search code examples
sqloracleplsqlvariable-declarationrowtype

In PL/SQL, can %ROWTYPE be re-used for another %ROWTYPE?


Or does it behave like a variable for which we have to use %TYPE?

declare
row1 emp%rowtype;
row2 row1%rowtype;
--row3 row1%type;
begin
null;
end;

Solution

  • Yes, you can use both %rowtype and %type, apparently both behave identically.