https://www.databasestar.com/oracle-nvl-nvl2-logical-functions/ The Oracle NVL function allows you to check a value and return a different value if that value is NULL. It’s great for using another value if the first one is NULL or an optional value, for example people’s phone numbers. It’s also good alongside aggregate functions and grouping so you can see what the difference is between a subtotal row and an actual NULL value. The syntax of the Oracle NVL function is: NVL( check_value, replace_value ) The parameters are: - check_value (mandatory): This is the value that is displayed to the user. It is also the value that is checked for NULL. - replace_value (mandatory): This is the value that appears if the check_value is NULL. The function can use many different data types as parameters: string, date, or numeric. However, both parameters need to be the same type. For more information about the Oracle NVL function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-nvl-nvl2-logical-functions/ /// RESOURCES 📝 Get my free SQL Cheat Sheets: https://www.databasestar.com/get-sql-cheat-sheets/ 🧭 SQL Roadmap from basics to advanced: https://www.databasestar.com/sql-roadmap/ ✍️ Learn how to design a database: https://databasestar.mykajabi.com/edd 🎓 Improve your SQL and database skills with Database Star Academy: https://www.databasestar.com/dsa/ 📧 Contact me here: https://www.databasestar.com/contact/ 📝 Database Design Exercises: https://bbrumm.gumroad.com/l/hqsxi 📝 SQL Practice Questions: https://bbrumm.gumroad.com/l/ulekqk 📝 SQL Performance Quick Guide: https://bbrumm.gumroad.com/l/fcvny 📝 Ultimate SQL How-To Guide: https://bbrumm.gumroad.com/l/oqggau