i'm relatively new databases, can explain me why case?
e.g. following gives invalid character error:
dsn_tns = cx_oracle.makedsn(ip, port, sid) # cx_oracle.connect([user, password, dsn, mode, handle, pool, threaded, events, cclass, # purity, newpassword, encoding, nencoding, edition, appcontext, tag, matchanytag]) conn = cx_oracle.connect(user = username, password = password, dsn = dsn_tns) cur = conn.cursor() cur.execute("select * mytable;")
the execute()
method takes single sql command, , semicolon never part of command. used separate multiple commands executed in sequence.
Comments
Post a Comment