Use Decode Function for Oracle Queries September 13, 2000 Decode is a very useful and handy function for Oracle queries. Itreplaces the complex If-Then-Else logic, which is used to display different things based on different values in a column.