Hi List, I need to convert this cursor of Oracle to Postgres... I wait for your help!!
*declare** v_num_dep integer := &v_num_dep; v_cont integer:=0; cursor cursor_dep is select * from hr.employees where hr.employees.department_id = v_num_dep; reg_dep cursor_dep%rowtype; begin for reg_dep in cursor_dep loop v_cont := v_cont + 1; dbms_output.put_line (to_char(reg_dep.last_name)||' '|| to_char(reg_dep.salary)||' '|| to_char(reg_dep.manager_id)); exit when v_cont=v_num_dep; end loop; end; *