I am no expert in Oracle / SQL....
In PL/SQL I want to execute a Select dependent of a variable.
I know, this example is not okay, but it illustrates what I mean:
case when ¶m = 1 then (select a,b,c from table)
when ¶m = 2 then (select d,e,f from table)
else (select g,h,i from table)
That is, when I run the sql, it prompts me for a parameter and dependend of the entered value, different values are selected from the table