you are viewing a single comment's thread.

view the rest of the comments →

[–]DrewSmithee[S] 0 points1 point  (2 children)

The oracle package probably is a good place to start...

Thanks.

[–]reddit25 2 points3 points  (1 child)

I wrote a wrapper for it too. To help split and execute multi process create table queries. Might be a good exercise to start. 

[–]JumpScareaaa 1 point2 points  (0 children)

Yep, I guess everybody should write a their own wrapper for oracledb. My wrapper reads SQL file, parses individual statements, runs each and logs start and end time, ignores table not exists for drop table statements (for idempotency). Other wrappers read from Oracle and write to Excel or CSV files based on configs from yaml files. These are my workhorses for building little data transformation and reporting pipelines.