User Paramter &

 Hi,

How can I configure to use the substitute value (&)?

select TO_DATE('&Date', 'dd/mm/yyyy') from dual;

DataGrip should prompt for Date, we can then enter 01/01/2017 for example.

This work right out of the box for Oracle SQL Developer, Toad and AllAround PL/SQL Developer.

Thanks.

eprasart.