Expert
3-16. | Does PL/SQL offer a CASE statement? |
3-17. | How can you emulate a CASE statement in PL/SQL? |
3-18. | DECODE offers an implementation of inline conditional logic; you can build an expression that contains an IF statement inside it. DECODE is not available in PL/SQL without executing a SELECT. How can you emulate DECODE (i.e., build a function that acts like DECODE) in native PL/SQL functionality? |
Get Oracle PL/SQL Programming: A Developer's Workbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.