0

I actually found something here but I need a syntax for multiple tables. Example:

DECLARE
    CURSOR select_results IS
        SELECT T1.ID, T2.DP FROM T1, T2 WHERE T1.ROW_ID=T2.DP;
    select_result T1.ID%ROWTYPE, T2.DP%ROWTYPE;
BEGIN
    -- DO SOMETHING
END;

Could someone explain how can I create such custom table variable and is it possible at all? Thanks in advance!

Community
  • 1
  • 1
nenito
  • 1,214
  • 6
  • 19
  • 33

1 Answers1

1

Try

select_result  select_results%ROWTYPE;

Share and enjoy.

Bob Jarvis - Слава Україні
  • 48,992
  • 9
  • 77
  • 110