Need help in incrementing the date in oracle
Note the extra brackets.

SQL&gt; variable d varchar2(100);
SQL&gt; exec :d := '09-DEC-2014';

PL/SQL procedure successfully completed.

SQL&gt; select '''' || (to_date(:d, 'DD-MON-YYYY') + 1) || '''' from dual;

''''||(TO_DATE(:D,'D
--------------------
'10-DEC-14'


Changing date format:

SQL&gt; alter session set nls_date_format='DD-MON-YYYY';

Session altered.

SQL&gt; select '''' || (to_date(:d, 'DD-MON-YYYY') + 1) || '''' from dual;

''''||(TO_DATE(:D,'DD-
----------------------
'10-DEC-2014'