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

6 votes168 views2 answers
Unity rotate vector around point
C#
1 vote155 views1 answer
The CodeDom provider type "Microsoft.CodeDom.Providers.DotNetCompilerPlatform.CSharpCodeProvider, Microsoft.CodeDom.Providers.DotNetCompilerPlatform, Version=2.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" could not be located.
C#
2 votes197 views2 answers
C# stop process
C#
0 vote152 views1 answer
Net use delete
C#
39 votes160 views1 answer
C sharp split string
C#
0 vote164 views1 answer
Scale curve revit api
C#
0 vote169 views1 answer
Windows form button image size
C#
0 vote158 views1 answer
User control equivalent event for form.shown c#
C#
0 vote121 views1 answer
Group by distinct c#
C#
2 votes157 views1 answer
How to read SQL Server COUNT from SqlDataReader
C#