PL/SQL

[dbomrrsm]

Is this at all possible in pl/sql:

IF (select 1 from dual) = 1 THEN
-- Do something
ELSE
-- Do Something Else
END IF;

I appreciate that you can populate the calue of the select statement into a variable and use that in the if but just want to know if the above is possible in any version of pl/sql.

Thanks

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[taupirho]

Well you do know that your posted pseudo-code is equivalent to just

-- Do something

but I guess you were looking for

declare
x number := 0;
begin

select 1
into x
from dual;

if x = 1 then
-- Do something
else
-- Do something else
end if;

end;


In order to understand recursion, you must first understand recursion.

 

[jimirvine]

You would need to give more detail than you currently have. Show us what you are actually trying to do rather than over simplifying and thereby opening up all sorts of other non-appropriate possibilites.