create a record with ROWTYPE and extra column

Question

I want to create a RECORD type based on a table which also contain an extra column. something like this:

type rec is record
(
  x urowid,
  test_exception%rowtype
);

inst_rec rec;

Thanks for any help

I'm afraid you're going to have to write all the fields of the test_exception table — pablomatico
– pablomatico, Commented Jun 8, 2016 at 8:56

Tony Andrews · Accepted Answer · 2016-06-08 09:52:22Z

4

You just need to name the rowtype part:

type rec is record
(
  x urowid,
  te_rec test_exception%rowtype
);

inst_rec rec;

For example, using the EMP table:

declare
   type t_emp_plus_rec is record
      ( emprec emp%rowtype
      , extra integer
      );
   emp_plus_rec t_emp_plus_rec;
begin
   emp_plus_rec.emprec.empno := 123;
   emp_plus_rec.emprec.ename := 'SMITH';
   emp_plus_rec.extra := 3;
end;

answered Jun 8, 2016 at 9:52

Tony Andrews

133k23 gold badges230 silver badges266 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

create a record with ROWTYPE and extra column

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related