This page (revision-4) was last changed on 26-Nov-2021 10:22 by rforbes

This page was created on 26-Nov-2021 10:22 by Administrator

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
4 26-Nov-2021 10:22 2 KB rforbes to previous
3 26-Nov-2021 10:22 2 KB rforbes to previous | to last
2 26-Nov-2021 10:22 1 KB Administrator to previous | to last
1 26-Nov-2021 10:22 1 KB Administrator to last

Page References

Incoming links Outgoing links
DECODE
DECODE

Version management

Difference between version and

At line 4 changed 3 lines
This Oracle function gives us the ability to have a function with an IF-THEN-ELSE type of construct.
The Oracle [CASE WHEN|ORACLE CASE WHEN] Construct often provides a clearer explanation of the logic.
This Oracle function gives us the ability to have a function with an IF-THEN-ELSE type of construct
At line 9 changed 7 lines
|EXPRESSION | The value you wish to evaluate
|SEARCH1 | The value that is compared to the Expression
|RESULT1 | What is returned if the Expression is equal to the value
|SEARCH2 | (optional) The value that is compared to the Expression
|RESULT2 | (optional) What is returned if the Expression is equal to the value
... et cetera ... as many search/result pairs as you need
|DEFAULT | (optional) What is returned if the Expression is not equal to any of the values provided.
|Expression | The value you wish to evaluate
|Search1 | The value that is compared to the Expression
|Result1 | What is returned if the Expression is equal to the value
… etc as many search/result pairs as you need
|Default | (optional) What is returned if the Expression is not equal to any of the values provided.
At line 18 changed one line
The same variable type as Expression
The same variable type as Expressionq
At line 28 changed one line
If you do not provide a Default value, and the expression is not equal to any of the search values provided, then NULL is returned.
If you do not provide a Default value, and the expression is not equal to any of the search values provided, then NULL is returned
At line 30 removed 2 lines
The type of data (date/number/character) of the first result must match the results of all the other values, otherwise you may get oracle errors.
At line 34 changed one line
{{DECODE(~,1000,'Alpha',2000,'Bravo','Charlie') }} will evaluate the variable passed and compare it to the numbers 1000 (return Alpha) or 2000 (return Bravo) and if neither of these values will return Charlie. In programming terms this would look like:
{{DECODE(~,1000,'Alpha',2000,'Bravo','Charlie') }}will evaluate the variable passed and compare it to the numbers 1000 (return Alpha) or 2000 (return Bravo) and if neither of these values will return Charlie. In programming terms this would look like:
At line 44 removed 5 lines
----
![Notes|Edit:Internal.DECODE]
[{InsertPage page='Internal.DECODE' default='Click to create a new notes page'}]
This page (revision-4) was last changed on 26-Nov-2021 10:22 by rforbesTop