Oracle10和JDBC:如何使CHAR在比较时忽略尾随空格？

SELECT * FROM table_name WHERE TRIM(column_name) = 'value';

String sql = "SELECT * FROM table_name WHERE TRIM(column_name) = ?";
PreparedStatement pstmt = connection.prepareStatement(sql);
pstmt.setString(1, "value");
ResultSet rs = pstmt.executeQuery();