There are some sql functions, such as case statements, and decode, and floor/cieling and rounding that I use regularly.