Insert with result of a select, how can I do this in Oracle?

0

Can anyone tell me how I can write to the Oracle database with Loop. When I run below it only writes the first record.

INSERT INTO
   BURD_400 (
      NIVEL,
      GRUPO
      ...
   )
SELECT
   BURD_ESTQ_300_MOVIMENTO_60D.NIVEL_ESTRUTURA,
     BURD_ESTQ_300_MOVIMENTO_60D.GRUPO_ESTRUTURA
FROM
   BURD_ESTQ_300_MOVIMENTO_60D
    
asked by anonymous 01.10.2018 / 22:50

0 answers