Spark JDBC query isn't working for Oracle Databases

[User15725630784]

I am trying to read with the following syntax

val df = spark.read

.format("jdbc")

.option("url", "<url>")

.option("query", "SELECT * FROM oracle_test_table)")

.option("user", "<user>")

.option("password", "<password>")

.option("driver", "oracle.jdbc.driver.OracleDriver")

.load()

df.show()

and am getting the following error

java.sql.SQLSyntaxErrorException: ORA-00911: invalid character

[User15725630784]

https://kb.databricks.com/data-sources/query-option-not-work-oracle.html#problem-apache-spark-jdbc-d...