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

Filed under:
|

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

Related posts about jython

Related posts about sql