left in oracle code example
Example 1: plsql left() function
SUBSTR( "20190601", 0, 6 )
Example 2: oracle leftmost characters
SUBSTR(<main-string>,1,<number-of-characters>)
SUBSTR('Useless stuff',1,10)
SELECT SUBSTR('Useless stuff',1,10)
FROM DUAL;
Example 3: oracle right characters
SUBSTR(<main-string>,-<number-of-characters>)
SUBSTR('Useless stuff',-9)
SELECT SUBSTR('Useless stuff',-9)
FROM DUAL;
Example 4: Subtr Oracle ?
SELECT DISTINCT city
FROM station
WHERE SUBSTR(city,1,1) IN ('A','E','I','O','U')
AND substr(city,-1) IN ('a','e','i','o','u');