title: Using a parameter in oracle query in pyspark
body: <p>I want to define a parameter that I will use in some queries in Oracle (through PySpark):</p>
  
  <pre><code>week='2020 w21'
  query=  f""" ( select*from table where week_in_year=week)main """
  </code></pre>
  
  <p>But unfortunately reading this gives me an error
  <code>ORA-00904: "week": invalid identifier</code></p>
  
  <p>The column "week_in_year" is also a string. How can I use this parameter in a query?</p>