Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> insert statement using a sequencer and query

insert statement using a sequencer and query

From: Larry Pettit <larry.pettit_at_ps.net>
Date: Mon, 13 Sep 1999 14:11:00 -0600
Message-ID: <HOcD3.992$wD5.69355@news.uswest.net>


I'm trying to do an insert with the first column being a sequence value and the rest coming from another table. Is it possible and if so what is the correct syntax or do I need to use a cursor? I've already created the sequence name_id_seq.

Thanks

    insert into table_name (seq_val, name_text, code)

       values(name_id_seq.nextval,
      (select name_text, code from another_table));







Received on Mon Sep 13 1999 - 15:11:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US