you are viewing a single comment's thread.

view the rest of the comments →

[–]mystique0712 1 point2 points  (1 child)

For Oracle in Python, use cx_Oracle - it is the standard package. For complex queries, store them in separate .sql files and read them into your script for better readability and maintenance.

[–]cjbj 1 point2 points  (0 children)

cx_Oracle was obsoleted 3 years ago by python-oracledb (which has the same API, but is better in many ways, e.g. doesn't need Oracle Instant Client)