How to create record type of two tables in PL/SQL?

Question

I have two tables A,B with lots of columns and a cursor

CURSOR Cur  
IS 
select A.*, B.* FROM A,B

I want to fetch the cursor into a TYPE that stored the rowtype of two tables. However, I do not want to create a TYPE by typing all of the column name of two tables. I tried the following but neither of them work.

--1

RecA                 A%RowType
RecB                 B%RowType
FETCH Cur INTO RecA, RecB

--2

RecA                 A%RowType
RecB                 B%RowType
RecAB                A||B%RowType
FETCH Cur INTO RecAB

P.S. The problem can be solved by using two cursors but I want to know is there a way to concat two rowtype.

Community · Accepted Answer · 2020-06-20 09:12:55Z

2

Reading the fine manual:

explicit_cursor_name

Name of an explicit cursor. For every column selected by the query associated with explicit_cursor_name, the record has a field with the same name and data type.

So you can simple say:

type cur_t is cur%rowtype;

Also see the examples.

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Nov 14, 2016 at 4:27

user272735

10.6k9 gold badges72 silver badges100 bronze badges

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

Collectives™ on Stack Overflow

How to create record type of two tables in PL/SQL?

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