Can't create condition in SQL query (ORA-00936: missing expression)

[s.paskevics]

My query:

SELECT name FROM test_table WHERE test_column_name LIKE ($P{PARAM_VALUE} == null ? "%" : $P{PARAM_VALUE})[/code]

what I did wrong?

 

[nthapa]

NA

[nthapa]

Can you see if any of the following this makes difference?

SELECT name FROM test_table WHERE test_column_name LIKE ($P{PARAM_VALUE} IS NULL ? "%" : $P{PARAM_VALUE})

 

SELECT name FROM test_table WHERE (test_column_name LIKE $P{PARAM_VALUE} and 

$P{PARAM_VALUE} IS NOT NULL ) or (test_column_name LIKE "%" and $P{PARAM_VALUE}) IS NULL)

[james.t]

This part of your query is actually Java code:

($P{PARAM_VALUE} == NULL ? "%" : $P{PARAM_VALUE})

so it won't work. You can't mix Java and SQL in a query.