Question: What is the difference between an "empty" value and a "null" value?
Answer: An empty string is treated as a null value in Oracle.
Demo
NIGT013.COLL_B_DATE is null, and apply NVL2 to substitute a value (i.e. empty string) when a null value is encountered.
But it showed null value in report. It results from an empty string is treated as a null value in Oracle
Therefore, in order to show non-null value in my report. Substitute two spaces when a null value is encountered.
Then it won't show null value in report anymore.
- Keep the installation structure SIMPLE.
- Always get rid of old files.
- Automate it
- Don’t over do it with the symlinks
- Delete everything first.
- Have a roll back strategy.
- Don’t make changes to your deploy mechanism or deploy scripts between deploying to different environments.
1. The all code is crap, except mine, attitude.
2. The “I fix that in a second” catastrophe.
3. The “That will only take a second” misconception.
4. The ego spiral.
5. “It wasn’t me!”
6. The demotivated genius.
7. The premature programmer.
