How to insert data to table from differences between this table and other one, using genereted sequence id?
<p>I have two tables and I try to insert rows from <code>SECOND_TABLE</code> to <code>FIRST_TABLE</code>.</p>

<p>I create two tables:</p>

<pre><code>CREATE TABLE FIRST_TABLE(
    F_ID NUMBER(10) not null,
    F_NAME VARCHAR(8 BYTE) not null,
    F_DESCRIPTION NVARCHAR2(1000) not null
  );


  CREATE TABLE SECOND_TABLE(
    S_ID NUMBER(10) not null,
    S_NAME VARCHAR(8 BYTE) not null,
    S_DESCRIPTION NVARCHAR2(1000) not null
  );
</code></pre>

<p>I found differences between <code>SECOND_TABLE</code> and <code>FIRST_TABLE</code>:</p>

<p><code>select S_NAME,S_DESCRIPTION from SECOND_TABLE minus select F_NAME,F_DESCRIPTION from FIRST_TABLE;</code></p>

<p>I create a statement:</p>

<p><code>insert into FIRST_TABLE F_ID,F_NAME,F_DESCRIPTION (select * from SECOND_TABLE where not exists (select * from FIRST_TABLE where SECOND_TABLE.S_NAME = FIRST_TABLE.F_NAME));</code>  </p>

<p>but this statement copy <code>F_ID</code>, I don't have idea how to change this statement to not copy <code>F_ID</code>, but generate it from sequence <code>CSS_F</code>. It should looks like:</p>

<p><code>insert into FIRST_TABLE (F_ID) values (CSS_F.nextval);</code></p>

<p>Could you give me an advice how to add inserting genereted id to this statement? </p>