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

0 vote130 views1 answer
Blazor image button
C#
1 vote133 views1 answer
What is type unity
C#
0 vote137 views1 answer
C# short max length
C#
1 vote137 views1 answer
Best way to compare byte array c#
C#
0 vote127 views1 answer
[Package Manager Window] Error while fetching labels: User is not logged in or user status invalid. UnityEngine.GUIUtility:ProcessEvent (int,intptr,bool&)
C#
0 vote140 views1 answer
Dotween do rotate on one axis
C#
0 vote136 views1 answer
Assert.Equal
C#
8 votes198 views1 answer
Point to mouse 2D Unity
C#Unity
0 vote131 views2 answers
C# list sort by property string
C#
0 vote139 views1 answer
How to make soft body OBJECT in unity
C#