+ 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
1 Answer
+ 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?