[sqlmap-users] How to use IF-THEN-ELSE or CASE-WHEN in Oracle to get data faster

[Rodrigo Z. S. <rod...@gm...>]

I am studying a case of SQL in Oracle. If I did a select and it result the
number N, I get the response for that. So if I did a complex call and it
result 42, I can use the way the sqlmap use to check it:

sqlmap test: 42>10 = true
sqlmap test  42>50 = false
....

But before doing various call, I can get this result with only one call.
But the result for 42 is null. What I need to do is:

if (result=42) return 10
if (result=41) return 4
if (result=40) return 7
...

So... I am trying how can I do this. Everything I tried to make a simple IF
or a CASE failed. I study the syntax here
<http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/case_statement.htm#LNPLS01304>
but
not is working.

Is it possible do this:

CASE complex_sql_return_number WHEN 0 THEN 1; WHEN 1 THEN 42; ELSE 100 END

Any ideas?