inserting number into oracle sql - using jython
Posted
by kdev
on Stack Overflow
See other posts from Stack Overflow
or by kdev
Published on 2010-03-25T16:53:36Z
Indexed on
2010/03/25
17:03 UTC
Read the original article
Hit count: 294
I have this insert command where iam trying to insert a number to be taken from loop
i=0
for line in column:
myStmt.executeQuery("INSERT INTO REVERSE_COL
( TABLE_NAME,COL_NAME,POS) values
(,'test','"+column[i]+"','"+i+"'")
i=i+1
POS IS NUMBER DATATYPE
but it works if i hard code as 1
i=0
for line in column:
myStmt.executeQuery("INSERT INTO REVERSE_COL
( TABLE_NAME,COL_NAME,POS) values
(,'test','"+column[i]+"',1")
I have tried only i , +i+ and other method but its not working any suggestion how to solve this .
Thanks everyone .
© Stack Overflow or respective owner