SQL Tutorial : DRL / DQL - Null Values
Let's learn about the next topic: Null Values
NULL VALUES:
*************
- ITS IS A UN AVAILABLE VALUES
- ITS IS NOT SAME AS ZERO OR BLANK SPACE
SELECT EMPLOYEE_ID,LAST_NAME,COMMISSION_PCT
FROM EMPLOYEES
In the above example I am getting COMMISSION_PCT as null.
We can replace the null values with any suggested string
SELECT EMPLOYEE_ID, LAST_NAME, nvl(COMMISSION_PCT,'No Commission') FROM EMPLOYEES
No comments:
Post a Comment