cx_Oracle SELECT statement with WHERE clause and single quote-CodePudding

import cx_Oracle

dsn_tns = cx_Oracle.makedsn('**********', '*******', service_name='***') 

conn = cx_Oracle.connect(user='******', password='*******', dsn=dsn_tns)

c = conn.cursor()
c.execute('select username,created from dba_users where username='USERNAME' ')
for row in c:
    print (row[0], '-', row[1]) # this only shows the first two columns. To add an additional column you'll need to add , '-', row[2], etc.
conn.close()

  File "*******************", line 9
    c.execute('select username,created from dba_users where username='MONITOR' ')
              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
SyntaxError: invalid syntax. Perhaps you forgot a comma?

WHat is wrong here , when I using single quote around username then I am getting this error .

CodePudding user response：

c.execute("""select username,created from dba_users where username= :USERNAME""", USERNAME = 'Cristiano Ronaldo')

CodePudding user response：

The syntax for your SQL statement is indeed incorrect. It isn't clear what the value of USERNAME is supposed to be. If it is just supposed to be the connected user you can just do this:

c.execute("select username, created from dba_users where username = user")

If you intend that as a parameter you can do this:

c.execute("select username, created from dba_users where username = :user",
          user=USERNAME)