How to add integers to char in Oracle 11g SQL?
Is it possible to do something like this in a PL/SQL block:
SELECT 'a'+1 FROM du开发者_开发百科al;
and the result should be "b".
Here is my solution
SELECT CHR(ASCII('a') + 1) FROM dual
but I bet there is something more tricky
精彩评论