INSERT using SEQUENCE . NEXTVAL with another SELECT

Question

I can insert with this query in ORACLE

INSERT INTO CONF_CODE (ID, OPTION_NAME, ISCHECKED) VALUES (SEQ_CONF_CODE.NEXTVAL, 'Producao', 0);

But I need to fill this table CONF_CODE with a SELECT from another table like this:

INSERT INTO CONF_CODE (OPTION_NAME, ISCHECKED)
SELECT DISPLAY_NAME, 0 FROM CONF_LABEL_LOCAL
WHERE "TYPE" = 2 ORDER BY ID;

I don’t include the ID in the first line even being a field not-null because I don’t know how to insert a NEXTVAL SEQUENCE with the SELECT down below.

I am using Dbeaver because my 'PL/SQL Developer' has expired

Any idea of solving?

Answer 1

You can use Quence on select include the "ID" in the insert:

INSERT INTO CONF_CODE (ID, OPTION_NAME, ISCHECKED)
SELECT SOMEDASEQUENCE.NEXTVAL, DISPLAY_NAME, 0 
  FROM CONF_LABEL_LOCAL
 WHERE "TYPE" = 2 ORDER BY ID;