Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to insert sequence value using prepared statement
db2group88_at_yahoo.com wrote:
>I am using oracle db server 10g on windows 2000 platform, the
>application use jdbc connection, all of the tables has a column named
>id, i would like to use sequence to insert the value to this column,
>as i know, you can insert sequence_name.nextvalu to this column for
>each insert row, but if our insert statement use prepared statement,
>how to prepare this column to insert sequence value? thanks
You could define an Insert ( Before or After) trigger to populate the column each time a new row is inserted.. Received on Wed Nov 03 2004 - 11:50:40 CST