I have problem to determine the quarter dynamically for the spool path
in the form W:\SG-323\TeamZentraleKatalogredaktion\Regelupdate\Q4_2017\Sonderlocken\dst_polizei-GDP.csv

SQL Developer Execution:
@test
set echo on
column filename new_val filename

--print Quarternr. with fixed date, but I need it based on sysdate

--SELECT TO_CHAR(TO_DATE('12/26/2012', 'MM/DD/YYYY'), 'Q') AS MY_QTR FROM DUAL;

With the command below I get 3 instead 1, How can I get the Quarternr after the Q letter ?

I get error 01830. 00000 - "date format picture ends before converting entire input string"
--SELECT TO_CHAR(TO_DATE(sysdate, 'MM/DD/YYYY'), 'Q') AS MY_QTR FROM DUAL;

--the year I get with
select 'W:\SG-323\TeamZentraleKatalogredaktion\Regelupdate\Q_' || to_char(sysdate, 'yyyy')|| '\Sonderlocken\dst_polizei-GDP.csv' filename from dual;

--Output without Quarternummer:
--FILENAME
--------------------------------------------------------------------------------------------
--W:\SG-323\TeamZentraleKatalogredaktion\Regelupdate\Q_2018\Sonderlocken\dst_polizei-GDP.csv


spool &filename

SQL> SELECT TO_CHAR(TO_DATE(sysdate, 'MM/DD/YYYY'), 'Q') AS MY_QTR FROM DUAL;
SELECT TO_CHAR(TO_DATE(sysdate, 'MM/DD/YYYY'), 'Q') AS MY_QTR FROM DUAL
                       *
ERROR at line 1:
ORA-01858: a non-numeric character was found where a numeric was expected


SQL> select to_char(sysdate,'Q') AS MY_QTR FROM DUAL;

M
-
1

1 row selected.