问具有单个匹配条件的sql查询中的OR子句

EN

Select t1.name, t1.value 
from table t1 
where t1.name = 'abc' 
  and ? in (t1.col, t1.value);

SELECT name, value
FROM   table
WHERE  name ='abc'
AND    ? IN ( col, value );

SELECT name, value
FROM   table t
       INNER JOIN
       ( SELECT ? AS input_var FROM DUAL ) v
       ON ( t.col = v.input_var OR t.value = v.input_var )
WHERE  name ='abc';

String sql = "select t1.name, t1.value from table t1 where t1.name =? and (t1.col = ? or t1.value = ?)";
int someVal = 10;
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString("abc");
ps.setInt(2, someVal);
ps.setInt(3, someVal);
ResultSet rs = ps.executeQuery();
while (rs.next()) {
    String name = rs.getString("name");
    String value = rs.getString("value");
}

declare
    some_val number := 10;
begin
    select t1.name, t1.value
    from table t1
    where t1.name ='abc' and (t1.col = some_val or t1.value = some_val);
end;
/