PPT Slide

SELECT empid, lastname, firstname, NVL(spouse,'unmarried') FROM HRAPP.EMP;

Now the result of this SELECT statement

action is:

EMPID LASTNAME FIRSTNAME SPOUSE--------- ------------ ------------- -----------39334 SMITH GINA FRED 49539 QIAN LEE unmarried

60403 HARPER ROD SUSAN 02039 WALLA RAJENDRA HARPREET 49392 SPANKY STACY unmarried

21

Previous slide

Next slide

Back to first slide

View graphic version