Uncommon functions in oracle

Oracle does not commonly use function 1, coalesce -- returns the first non-null parameter in the parameter list. The last value in the parameter list is usually the constant www.2cto.com. Case: If bonus is not null, result: bonus. If bonus is null, salary is not null. Result: salary * 15. If bonus is a slave, salary is null. Result: 100 SQL code select coalesce (bonus, salary * 15,100) bonus 2, case statement -- the branch statement in the database, which is equivalent to the switch-case in the database. if the job is Analyst, salary * 1.1 if the job is Programmer, salary * 1.05 if the job is clerk, salary * 1.02 other job, salary * 1 www.2cto.com SQL code select salary, case job when 'analyst' then salary * 1.1 -- note that there is no ", "when 'scheme' then salary * 1.05 when 'cler' then salary * 1.02 else salary -- else is equivalent to the default end new_salary in java -- end is the concluding sentence of the case statement.