zelark

with tab
     as (select 'aa' as p1, 'bb' as p2 from dual union all
         select 'cc' as p1, 'dd' as p2 from dual union all
         select 'ee' as p1, 'ff' as p2 from dual union all
         select 'gg' as p1, 'hh' as p2 from dual)

select max(case when rownum = 1 then p1 || p2 end) as r1,
       max(case when rownum = 2 then p1 || p2 end) as r2,
       max(case when rownum = 3 then p1 || p2 end) as r3,
       max(case when rownum = 4 then p1 || p2 end) as r4

zelark

create or replace procedure api(p1 out number,
                                p2 out number,
                                p3 out number)
as
begin
  p1 := 1;
  p2 := 2;
  p3 := 3;
end api;

zelark

declare
  l_number_i_am_interested_in number;
  l_p2_dummy number;
  l_p3_dummy number;
begin
  api(p1 => l_number_i_am_interested_in,
      p2 => l_p2_dummy,
      p3 => l_p3_dummy);
end;

zelark

declare
  l_number_i_am_interested_in number;
  l_dummy number;
begin
  api(p1 => l_number_i_am_interested_in,
      p2 => l_dummy,
      p3 => l_dummy);
end;

zelark

declare
  l_number_i_am_interested_in number;
  l_dummy number;
begin
  api(p1 => l_number_i_am_interested_in,
      p2 => l_dummy,
      p3 => l_dummy);
  dbms_output.put_line(l_dummy);
end;

zelark

create or replace procedure api(p1 out number,
                                p2 out number,
                                p3 out number,
                                p4 out number,
                                p5 out number,
                                p6 out number,
                                p7 out number,
                                p8 out number,
                                p9 out number)
as

zelark

declare
  l_number_i_am_interested_in number;
  l_dummy number;
begin
  api(p1 => l_number_i_am_interested_in,
      p2 => l_dummy,
      p3 => l_dummy,
      p7 => l_dummy,
      p8 => l_dummy,
      p9 => l_dummy,

zelark

# Try it out. It works!

x = [[1,2], [3,4], [5,6]]
x = [x for x in x for x in x]

# x = [1, 2, 3, 4, 5, 6]

zelark

a = [[1, 2], [3, 4], [5, 6]]
b = [x for l in a for x in l]

# b = [1, 2, 3, 4, 5, 6]

zelark

import traceback

def foo():
    x = [1, 2, 3]
    print(traceback.extract_stack())

if __name__ == '__main__':
    foo()