sábado, 8 de janeiro de 2022

Cursor com Oracle

 BEGIN

-- Create cursor and start loop

FOR C_PAR in (SELECT * FROM TGFPAR WHERE CODPARC < 100) LOOP

-- run commands for each item here

DBMS_OUTPUT.PUT_LINE(C_PAR.CODPARC || ' - ' || C_PAR.RAZAOSOCIAL);

END LOOP;

END;


Resultado:




Um comentário:

  1. The casino - drmcd
    The 안동 출장마사지 casino. The casino. The casino. No deposit bonus. No 세종특별자치 출장샵 free 삼척 출장마사지 spins. No code 강릉 출장안마 needed. No login needed. Use code: 'DUNCAN' 서산 출장샵

    ResponderExcluir

Postgres no docker

 -- Criar compose nano docker-compose.yml version: '3.7' ### services:   db:     image: postgres     volumes:       - postgres_data:...