Hi all
The DECODE statement allows you to select a value depending on another value.
Example:
The statement
SELECT
DECODE(i.ordno, "22", "twenty-two", "23", "twenty-three", "none")
FROM INVENTORY I
will give you "twenty-two", if i.ordno equals "22", "twenty-three", if i.ordno equals "23"...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.