Hi, friends!
I have a problem in my query to Oracle DB. I trying execute query with default variable value some like this:
SELECT p.*
FROM products p
WHERE p.createdAt = [[ {{dateOfCreation}} #]]CURRENT_DATE()
But in response i take error ORA-00907: missing right parenthesis. How to pass the default value in this case?
Much thanks!
P.S. Environments: Oracle DB 12c, Metabase 0.39.3