do we have if/then/else in sqlplus?

[thg]

can you give me the syntax? where can I find the decode function?

The reason I asked this is because I want to execute some alter table statement in my script base on the result of a database query.


let's say the binding variable version is the result from the db query, then I would do things like this

if (version < 4) then
--execute some db update querys
else
-- do nothing
end