PPT Slide

The effects of omitting the third parameter

in the substr( ) function:

SELECT title, SUBSTR(title,5,5) CHARS FROM SONGS;TITLE CHARS------------------- -----"HAPPY BIRTHDAY" Y BIR"DIAMONDS AND RUST" ONDS "AMAZING GRACE" ING GSELECT title, SUBSTR(title,5) CHARACTERS FROM SONGS;TITLE CHARACTERS------------------- ---------------"HAPPY BIRTHDAY" Y BIRTHDAY""DIAMONDS AND RUST" ONDS AND RUST""AMAZING GRACE" ING GRACE"

15

Previous slide

Next slide

Back to first slide

View graphic version