Oracle null date

Check for Null and optionally you can assign a default date value. No Account? Sign up. By signing in, you agree to our Terms of Use and Privacy Policy. Already have an account? Sign in. By signing up, you agree to our Terms of Use and Privacy Policy. Enter the email address associated with your account. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels.

And of course, keep up to date with AskTOM via the official twitter account. Question and Answer. You Asked Hello, Tom! This can for instance be helpful when using ranges.

The else clause is optional. NULL values are one of the most mind-boggling values in the Oracle database. Find out more. Fortnightly newsletters help sharpen your skills and keep you ahead, with articles, ebooks and opinion to keep you informed.

View all articles by Patrick Barel. FROM emp t. WHERE t. NVL expr1 , expr2. NVL2 expr1 , expr2 , expr3. LNNVL condition. FROM emp e.

AND e. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name.

Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science. Stack Gives Back Featured on Meta.