Null: Databases for Developers #10

The null value represents missing or unknown information.
But using it brings complications to your SQL. In this video Chris discusses how to work with null to ensure you get the correct results.
Further reading:
Oracle Database SQL Reference on Nulls: docs.oracle.com/database/122/S...
Null related functions: docs.oracle.com/database/122/S...
Is null condition: docs.oracle.com/database/122/S...
Need help with SQL? Ask us over on AskTOM: asktom.oracle.com
Twitter: / chrisrsaxon
Daily SQL Twitter tips: / sqldaily
All Things SQL blog: blogs.oracle.com/sql/
============================
The Magic of SQL with Chris Saxon
Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.

[@sejalp]

Good information, but the background music is really distracting and difficult to hear the statements with music constantly going on.

[@TheMagicofSQL]

Thanks; we'll bear your comments on the music in mind for future videos

[@newagene8276]

thank you for such a great way of teaching..

[@ThingAboutDatabases]

Hey Chris, No New Videos, Its long time since you posted a new video, Can you post something about using XML and JSON datatypes, Would be great to get some hands on based on your interactive explanations...

[@TheMagicofSQL]

Thanks for the suggestion, I've got a lot in the pipeline, stay tuned next year! :)

[@arturk9181]

I hate magic values, I had a spreadsheet of them on one of the projects I worked on. Nulls and filtering all the way

[@NadiraJamal]

I'm with you. Dealing with null is hard because you have to know what you're doing and remember to accommodate it, but you can learn and/or check the documentation. I have never worked with magic values, but they seem like a recipe for making mistakes. You have to know which values are magic, remember that they exist, and remember which situations you do and don't have to accommodate their magicness. Who is going to remember that 6 months later?

[@dbgeek]

Hi Chris,
Can you please let me know how can I add my questions to asktom.oracle.com. I have created an account out there but I can't add my questions regarding the Oracle server.

[@TheMagicofSQL]

We're taking a break over the Christmas period!
We'll be back taking questions again soon. Note - you don't need an account to post questions.

[@JacMarJac]

You are a brilliant man, but please remove the noisy "foreground" music!