Decode in oracle

DECODE (condition, value 1, translation value 1, value 2, translation value 2,... value n, translation value n, default value) </p>

Value indicates any column of any type in a table or any result obtained by calculation. When each value is tested, if the value is if1, the result of the Decode function is then1; if the value is if2, the result of the Decode function is then2; and so on. In fact, multiple if/then pairs can be provided. If the value result is not equal to any given pairing, the Decode result returns else. <Br/>

Note that if, then, and else can both be functions or computing expressions. <Br/>

 

 

For example:

Decode (s. billcontent, 'Flowers ', '1', 'green plant', '2', 'gift ', '3 '),

 

Author "lin213-213"