rowtype [Oracle PL/SQL]

create table rowtype_tbl_example (
  a  number,
  b  varchar2(10),
  c  date
);

declare
  r  rowtype_tbl_example%rowtype;
begin
  r.a := 4;
  r.b := 'bla';
  r.c := sysdate;

  insert into rowtype_tbl_example values r;
end;
/

select * from rowtype_tbl_example;

         A B          C
---------- ---------- -------------------
         4 bla        17.05.2006 23:18:11

declare
  r rowtype_tbl_example%rowtype;
begin
  r.a := 4;
  r.b := 'FOO';
  r.c := sysdate + 1;

  update rowtype_tbl_example set row = r 
   where a = r.a;
end;
/

select * from rowtype_tbl_example;

         A B          C
---------- ---------- -------------------
         4 FOO        18.05.2006 23:18:46

declare
   r  rowtype_tbl_example%rowtype;
begin

  select * into r from rowtype_tbl_example;

  dbms_output.put_line('r.a: ' || r.a);
end;
/

r.a: 4