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

Home -> Community -> Usenet -> c.d.o.server -> how to insert sequence value using prepared statement

how to insert sequence value using prepared statement

From: <db2group88_at_yahoo.com>
Date: 3 Nov 2004 09:04:19 -0800
Message-ID: <111e249e.0411030904.3f9f3b0a@posting.google.com>


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 Received on Wed Nov 03 2004 - 11:04:19 CST

Original text of this message

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