Default variable value in Oracle DB query

Hi, friends!

I have a problem in my query to Oracle DB. I trying execute query with default variable value some like this:

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

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.

1 Like

Hello @flamber, I tried out using -- as the comment syntax as I'm also connecting to Oracle (11G), but I'm not getting the desired result

What am I missing?

  "browser-info": {
    "language": "en-US",
    "platform": "Win32",
    "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/ Safari/537.36",
    "vendor": "Google Inc."
  "system-info": {
    "file.encoding": "UTF-8",
    "": "OpenJDK Runtime Environment",
    "java.runtime.version": "",
    "java.vendor": "Eclipse Adoptium",
    "java.vendor.url": "",
    "java.version": "",
    "": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "",
    "": "Linux",
    "os.version": "3.10.0-1160.36.2.el7.x86_64",
    "user.language": "en",
    "user.timezone": "GMT"
  "metabase-info": {
    "databases": [
    "hosting-env": "unknown",
    "application-database": "mysql",
    "application-database-details": {
      "database": {
        "name": "MySQL",
        "version": "8.0.19"
      "jdbc-driver": {
        "name": "MariaDB Connector/J",
        "version": "2.7.6"
    "run-mode": "prod",
    "version": {
      "date": "2022-10-17",
      "tag": "v0.44.5",
      "branch": "release-x.44.x",
      "hash": "29fab4d"
    "settings": {
      "report-timezone": "Africa/Lagos"