DECODE    IF x THEN return y ELSE return z

select DECODE('A','B','True','False')  from dual

Result : False

select DECODE('A','A','True','False')  from dual

Result : True

INITCAP(char) String with Initial Capitals

select initcap('oracle')  from dual

Result : Oracle

select initcap('oracle database')  from dual

Result : Oracle Database

More functions :  Oracle Date |  Oracle add_months function | Oracle ASCII function