INFORMIX存储过程中实现排序后结果insert到表的方法

 

1、建立测试表：

 

create table test_table1(t1 integer,t2 integer);

insert into test_table1 values(1,2);

insert into test_table1 values(2,2);

 

 

create table test_table(t1 integer,t2 integer)

 

2、建立存储过程：

CREATE PROCEDURE soa_tet()

DEFINE v_t1 integer;

DEFINE v_t2 integer;

FOREACH

         SELECT first 2 t1,t2

         INTO v_t1,v_t2

         FROM test_table1

         where 1=1 order by t1

 

         insert into test_table(t1,t2) values(v_t1,v_t2)

         ;

END FOREACH;

END PROCEDURE;

 

3、测试

execute procedure soa_tet();

 

select * from test_table