Delete
Do Record
Setting
Add New Item
Menu List
| Title | Content Type | Order | Action | ||||||
|---|---|---|---|---|---|---|---|---|---|
| {{kb_content.name}} {{kb_content.name}} | {{setValue(content_types, kb_content.content_type)}} | {{kb_content.sort_order}} | Preview Edit Edit Content | ||||||
| {{kb_content.name}} | {{setValue(content_types, kb_content.content_type)}} | {{kb_content.sort_order}} | Preview Edit Edit Content | ||||||
| No record | |||||||||
Status: published
Programming, Software and application
2020-12-07 03:13:23
Oracle Comparison Functions
1828
Introduction to Oracle Database Oracle Tables and Data definition Modifying data Oracle Query and Filter Oracle data types Joining tables Oracle Operators Grouping data Constraints
COALESCE – show you how to substitute null with a more meaningful alternative.
DECODE – learn how to add if-then-else logic to a SQL query.
NVL – return the first argument if it is not null, otherwise, returns the second argument.
NVL2 – show you how to substitute a null value with various options.
NULLIF – return a null if the first argument equals the second one, otherwise, returns the first argument.
Glossary List