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 .
Advertisement
Answer
c.execute( """select username, created from dba_users where username=:USERNAME""", USERNAME = 'Cristiano Ronaldo' )