Q:

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 dual;
and the result should be "b".

A:

Here is my solution
SELECT CHR(ASCII('a') + 1) FROM dual

but I bet there is something more tricky

