Describe the Oracle decode function usage

The following articles mainly describe the correct usage of the Oracle decode function. We all know that the Oracle function library provides functions with more than N practical special numbers, such as nvl, sign and round, which are frequently used. The decode function is the most powerful function. The function is used as follows:

Decode (expression, condition 1, result 1, condition 2, result 2,...) contains several conditions and results depending on the individual, as shown in

Decode (sign (100-20), 1,100,-100) means that when 100-20) is greater than zero, the result is 20, and when-20) is less than zero, the result is 100. The sign is only a function for determining the symbol.

If we want to adjust the salaries of employees in an enterprise and increase the salaries by 3000 for employees of less than 10% yuan and 3000 for employees of more than 5% yuan, then our general practice is to judge the wages, if the value is greater than 3000, 5% is added, and if the value is lower than 3000, 10% is added. However, with this Oracle decode function, you can simply use the following statement:

 
 


  
  
Select decode (sign (salary-3000), 1, salary * 1.1,-1, salary * 1.05) from employee

 
 

The above content describes the usage of the Oracle decode function, hoping to help you in this regard.