Decode (expression, search_1, result_1)
Returns result_1 if expression results =search_1 results, similar to if else
Decode (expression, search_1, Result_1, search_2, result_2)
Decode (expression, search_1, Result_1, search_2, Result_2, ....., Search_n, Result_n)
Decode (expression, search_1, result_1, default)
Returns result_1 if expression results =search_1 the result, or back to default
Decode (expression, search_1, Result_1, search_2, result_2, default)
Decode (expression, search_1, Result_1, search_2, Result_2, ....., Search_n, result_n, default)
The decode function compares the expression with the search word, returns the result if it matches, returns the default value if it does not match, or returns a null value if no default value is defined.
Such as:
Select (a/b*100) as percent from T
If B is 0, a divisor of 0 is present.
Solve:
Select Decode (b,0,0,a/b*100) as percent from T
Oracle decode function divisor is zero