oracle行转列——游标方式实现

--废话不多说，直接上代码。

create table tb(row_number int,random_value int);

insert into tb(row_number,random_value) values(1,2);
insert into tb(row_number,random_value) values(1,2);
insert into tb(row_number,random_value) values(1,2);
insert into tb(row_number,random_value) values(1,2);
insert into tb(row_number,random_value) values(1,2);
insert into tb(row_number,random_value) values(1,2);
insert into tb(row_number,random_value) values(1,2);
commit;

declare

  col1   number;
  col2   number;
  v_sql  varchar2(4096) := '';
  v_sql2 varchar2(4096) := '';
  cursor cursor_hzl is
    select t.row_number, t.random_value from tb t;
  i cursor_hzl%rowtype;
begin
  for i in cursor_hzl loop
    v_sql  := v_sql || ',' || i.row_number;
    v_sql2 := v_sql2 || ',' || i.random_value;
  end loop;
  dbms_output.put_line(v_sql);
  dbms_output.put_line(v_sql2);
end;