Oracle Comparison Functions
Oracle Database Basic Course
Created by :
Database, Oracle
course
Programming, Software and application
1756
2020-12-07 03:13:23
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
Glossary {{x+1}}:
- A. {{kb_content_item.question_option.option_1}}
- B. {{kb_content_item.question_option.option_2}}
- C. {{kb_content_item.question_option.option_3}}
- D. {{kb_content_item.question_option.option_4}}
- E. {{kb_content_item.question_option.option_5}}
- F. {{kb_content_item.question_option.option_6}}
Answer:
{{kb_content_item.answer}}Answer:
{{kb_content_item.answer}}Explanation:
Tags:
{{obj.value}}
- Database Overview
- What Is Oracle Database
- History of Oracle Database
- Why Oracle Database
- Features of Oracle Database
- Oracle Vs. SQL Server: Key Differences
- Oracle Vs. MySQL Server: Key Differences
- Oracle Vs. NoSQL
- Install Oracle Database Server
- Oracle Database Sample Schema
- Execute Sample Database
- Connect to SQL Developer and Other SQL Editor