Default variable value in Oracle DB query

Get Help
#1

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

#2

Hi @rchernov
Oracle uses -- for comment syntax instead of #
And if you're using Field Filters, then you don't include the column in the query, which means you'll have to include it after the comment.