Oracle - If variable is null?

Question

I need to return some dummy select when my variable matches string. This is what I tried: begin if :someVar = 'Yes' then select 1 from dual; end if; end; / I've tried declaring a variable for INTO clause, but I allways receive error "**PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following..**". Can somebody show what should I change to get desired select ? I'm beginner in Oracle, and I need this for SSRS reports, for setting parameter default values (based on another parameter - which is **someVar** in my question).

Answer 1

i see from your block that you don;t want to take any action if someVar = 'Yes'

then just use NULL inside the If statement. see below:

begin

if :someVar = 'Yes'

then

NULL;

end if;

end; /

Ifyou want to store or display this dummy variable, then you need to delcare it and usine INTO in the dummy sql

like below:

DECLARE

v_dummy NUMBER;

begin

if :someVar = 'Yes'

then

select 1 into v_dummy from dual;

end if;

end; /

hope this helps!