Create cursor in NETEZZA

CREATE OR REPLACE PROCEDURE SP_NEW_PROCEDURE1( )
RETURNS REFTABLE(employees)
LANGUAGE NZPLSQL AS
BEGIN_PROC
  DECLARE

l_conditions  varchar(1000);
p_rec         RECORD;

BEGIN

FOR P_REC IN  select empid, mgrid, empname, salary  from employees where mgrid = 7 
LOOP


        l_conditions  :=  'insert into  '  || 
                          REFTABLENAME     || 
                          '  VALUES ('     || 
                          quote_literal(P_REC.EMPID)  || 
                          ','              || 
                          quote_literal(P_REC.MGRID)    || 
                          ','              || 
                          quote_literal(P_REC.EMPNAME)   || 
                          ','              || 
                          quote_literal(P_REC.SALARY )    || 
                          '  ) ; ' ;

 execute immediate l_conditions; 

  l_conditions  := ' ';

END LOOP;      
RETURN REFTABLE;
END;
END_PROC;

Source: stackoverflow.com

Similar codes

18 votes160 views3 answers
Get random from list c#
C#
0 vote151 views1 answer
Unity3d find y position on navmesh
C#
0 vote149 views1 answer
C# quaternion eular calculator
C#
0 vote151 views1 answer
Xamarin c# switch on hotspot Programmatically
C#
1 vote148 views1 answer
Arcane
C#
0 vote138 views1 answer
Mvc input number rounding
C#
1 vote181 views1 answer
Create gaps / headers between variables in the unity inspector
C#
4 votes144 views1 answer
How to get rigidbody speed in unity
C#
1 vote144 views1 answer
How to delete multiple file by datagridview in c#
C#
0 vote191 views1 answer
C# datetime dd/mm/yyy hh:mm:ss
C#