+ 3

Question IF Input = APPLEA THEN Output = aPPLEA solve this using character functions ( oracle SQL)

this is Oracle sql question , use single row functions and try to get this output

19th Aug 2017, 4:49 AM
mayur
mayur - avatar
1 Respuesta
+ 1
i didnt think about the exat syntax, but it should be like: select the row from table, use substr to choose the first letter, use lower to set that to lowercase. (the second part is with "select into"). am I right?
24th Aug 2017, 5:36 PM
Sadegh