title: Can I create a macro which is only testing a condition?
body: <p>the following query doesn't work if doesn't comment WHERE fc().</p>
  <pre><code>WITH
   FUNCTION ft 
          RETURN VARCHAR2 SQL_MACRO(table)
      IS
      BEGIN
          RETURN q'{
        ta
    }';
      END;
  
   FUNCTION fc 
          RETURN VARCHAR2 SQL_MACRO(scalar)
      IS
      BEGIN
          RETURN q'{
        1=1
    }';
      END;
        ta(v) as (select 1 from dual)  
  SELECT *
    FROM ft()
   WHERE fc()
  </code></pre>
  <blockquote>
  <p>ORA-00920: invalid relational operator</p>
  </blockquote>
  <p>Have I done some syntax error or isn't it possible to make macro returning a condition?</p>
  <p><a href="https://dbfiddle.uk/?rdbms=oracle_21&amp;fiddle=c10a779f7a2847a4597ffe1a25418108" rel="nofollow noreferrer">code</a></p>