Convert a column from boolean to integer in JDBC activity using insert statement

I have a column as integer in oracle DB , i have boolean data to send to this column , i am firing below query to DB

 

INSERT INTO table

(decode(col, true(),1,false(),0),col2,col3)

 VALUES(?,?,?)

 

For now this query doesnt help to convert boolean to integer

Could someone help me with conversions , requirement is to apply conversion in insert statement only

 

 

1 Comment

You need to find an SQL language reference. This really has nothing to do with TIBCO.

Don Johnson - Oct 11, 2019 - 8:47am
+ Add a Comment
Login