Oracle queries with single quotes

Select * from table where a = '['0', 'female'], ['1', 'mal'] ', a query statement with single quotes in oracle query; later, you can use chr (39) for data query to convert the single quotation mark format as follows: select '[' | chr (39) | '0' | chr (39) | ',' | chr (39) | 'female '| chr (39) |'] '| ', '|' ['| chr (39) | '1' | chr (39) |', '| chr (39) | 'male' | chr (39) | '] 'translation from dual. Therefore, you have to escape the client parameters. String Strinfo = "['0', 'female '], ['1', 'male']"; StringBuffer str = new StringBuffer (); for (int I = 0; I <Strinfo. length (); I ++) {String ss = Convert. toString (Strinfo. charAt (I); if (ss. repeated signorecase ("[") {str. append ("'[' |");} else if (ss. repeated signorecase ("'") {str. append ("chr (39) |");} else if (ss. equalsIgnoreCase ("]") {if (I! = Strinfo. length ()-1) {str. append ("']' |");} else {str. append ("']'") ;}} else {str. append ("'" + Strinfo. charAt (I) + "'|") ;}through the above method we can query. Select * from table where a in (select '[' | chr (39) | '0' | chr (39) | ',' | chr (39) | 'femal' | chr (39) | ']' | ',' | '[' | chr (39) | '1' | chr (39) | ',' | chr (39) | 'male' | chr (39) | '] 'translation)