Background EXAjload is a standard tool for bulk data loading. Its
documentation is brief, but the tool is more powerful than you might
think. It is possible to: import data from STDOUT of other processes
without creating a tmp file on disk; import da...
Thank you! I have a lot of stuff on my mind, but it's hard to measure
the actual interest. The best topics require a lot of text to explain
(e.g. UDFs logging and memory management), and only a small number of
customers can actually use it in product...
I think it's better to go other way and implement a simple ETL script,
which is going to: 1) Check if something needs to be imported /
synced.2) Run the actual IMPORT.3) Set "sync-status" in external
database. Running a simple query in Oracle is very...
I do not think it is possible to use a placeholder for array of
identifiers. It might be a good idea to switch to general programming
language (Python, Java, etc.) to generate complex SQL's like this.
You'll have 100% flexibility in SQL text generati...