How to handle forward slash(/) in java jdbc while querying for a particular value?

Viewed 648

Below is my query which is successfully working in command window but in JDBC I am unable to get the result set for this.

select * From Elp_Dealer_Recon_Wrk where CERTIFICATE='FACTURA MTY10745/24';

The same query if I use in cmd window it will return the result set and in jdbc its not returning any result set

Instead of FACTURA MTY10745/24 if I am giving some other value in the table its fetching the records in jdbc.

Can anyone help me on this please

1 Answers
Related