Why does this query throw this error in Python?

Question

Code(in Python):

cur.execute("SELECT * FROM ALL_BOOKS WHERE SUBJECT=\'BIO\';")

Error:

ORA-00933: SQL command not properly ended

Popeye · Accepted Answer · 2020-07-10 11:53:27Z

1

Remove ; from the query and try:

cur.execute("SELECT * FROM ALL_BOOKS WHERE SUBJECT='\BIO\'")

answered Jul 10, 2020 at 11:40

Popeye

36k4 gold badges12 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

It was the semicolon actually. It wasn't needed there. Either ways, thanks.