PPT Slide

Using the lpad( ) function in SELECT statements:

If the lpad( ) operation had been used

instead, the result would have been as follows:

SELECT empid, lastname, firstname, LPAD(DECODE(sex,'M','MALE','F','FEMALE'),10,'-') sex

FROM empORDER BY empid DESC;EMPID LASTNAME FIRSTNAME SEX----- -------- --------- ----------60403 HARPER ROD ------MALE49539 QIAN LEE ----FEMALE49392 SPANKY STACY ----FEMALE39334 SMITH GINA ----FEMALE02039 WALLA RAJENDRA ------MALE

09

Previous slide

Next slide

Back to first slide

View graphic version