Syntax & Example

In Syntax & Example section, instead of having detailed learnings on any topic I will provide a snippet of syntax and its example that will be handy to you during development or support tasks. You can bookmark this page and could use it when you forget syntax of an oracle function that you want to use.

Oracle Terms

Click on the term to see its syntax and example.

Set 1Set 2Set 3
FunctionMAX()NVL()
INSTR()SUBSTR()NVL2()
ProcedureMIN()COALESCE()