Insert as a result of a select, how can I do this on Oracle?

Asked

Viewed 24 times

0

Someone can tell me how to record in the Oracle bank with Loop. When I run below it only saves 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
  • Shows some error?

  • Dude, your command is correct. select returns how many lines?

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.