Solucionado
Olá!
Eu só gostaria de entender por que o professor fez um select na tabela DUAL após a inserção dos novos registros.
INSERT ALL
INTO PRODUTOS (CODIGO, DESCRITOR, SABOR, TAMANHO, EMBALAGEM, PRECO_LISTA)
VALUES ('1040110','Light - 350 ml - Jaca', 'Jaca','350 ml', 'Lata', 6.00)
INTO PRODUTOS (CODIGO, DESCRITOR, SABOR, TAMANHO, EMBALAGEM, PRECO_LISTA)
VALUES('1040111','Light - 350 ml - Manga', 'Manga','350 ml', 'Lata', 3.50)
SELECT * FROM DUAL;Obrigado.
Eu consegui entender por esse link: https://www.oracletutorial.com/oracle-basics/oracle-insert-all/ .Segue a explicação do site :
insert multiple rows into a table, you use the following Oracle INSERT ALL statement:
INSERT ALL
INTO table_name(col1,col2,col3) VALUES(val1,val2, val3)
INTO table_name(col1,col2,col3) VALUES(val4,val5, val6)
INTO table_name(col1,col2,col3) VALUES(val7,val8, val9)
Subquery;In this statement, each value expression val1, val2, or val3 must refer to a column returned by the select list of the subquery.
If you want to use literal values instead of the values returned by the subquery, you use the following subquery:
SELECT * FROM dual;
INSERT ALL
INTO fruits(fruit_name, color)
VALUES ('Apple','Red')
INTO fruits(fruit_name, color)
VALUES ('Orange','Orange')
INTO fruits(fruit_name, color)
VALUES ('Banana','Yellow')
SELECT 1 FROM dual;