Select * into table%rowtype : ROWTYPE « PL SQL Data Types « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. PL SQL Data Types
3. ROWTYPE

SQL>
SQL> create table T (
  2   c1 number,
  3   c2 number );

Table created.

SQL>
SQL> insert into T values (1,2);

1 row created.

SQL>
SQL> create or replace procedure WITH_ROWTYPE is
  2     r T%ROWTYPE;
  3  begin
  4     select * into r from T where rownum = 1;
  5  end;
  6  /

Procedure created.

SQL>
SQL>
SQL> drop table t;

Table dropped.