Hello!! i am trying to ser a variable with to_char(sysdate, 'YYYY') but I am not able to do that
the last think I have tried is:
- create a query iterator qi1 with select to_char(sysdate, 'YYYY') query_year from dual
- inside iterator set a variable with value %qi1.query_year%
but it does not work.
Please, do you know how I can assign to_char(sysdate, 'YYYY') to a variable ?
Thanks in advance!