HomeНаука и техникаRelated VideosMore From: The Magic of SQL

Null: Databases for Developers #10

27 ratings | 2587 views
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: http://docs.oracle.com/database/122/SQLRF/Nulls.htm#SQLRF30037 Null related functions: http://docs.oracle.com/database/122/SQLRF/Single-Row-Functions.htm#SQLRF51187 Is null condition: http://docs.oracle.com/database/122/SQLRF/Null-Conditions.htm#SQLRF52152 Need help with SQL? Ask us over on AskTOM: https://asktom.oracle.com Twitter: https://twitter.com/ChrisRSaxon Daily SQL Twitter tips: https://twitter.com/SQLDaily All Things SQL blog: https://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.
Html code for embedding videos on your blog
Text Comments (7)
Jacob Martin Jacobsen (5 months ago)
You are a brilliant man, but please remove the noisy "foreground" music!
Sejal Parikh (7 months ago)
Good information, but the background music is really distracting and difficult to hear the statements with music constantly going on.
The Magic of SQL (7 months ago)
Thanks; we'll bear your comments on the music in mind for future videos
Kapil Kumar (11 months ago)
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.
The Magic of SQL (11 months ago)
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.
PARVEEN KUMAR (1 year ago)
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...
The Magic of SQL (1 year ago)
Thanks for the suggestion, I've got a lot in the pipeline, stay tuned next year! :)

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.