IMPORT FROM ORA supports multiple Statements
Details
| Detail name | Value |
|---|---|
| Changelog Number | 2720 |
| Type | Improvement |
| Status | Resolved |
| Fix Versions | EXASOL 6.0.9 |
| Resolution Date | 2018-03-06 |
Now IMPORT FROM ORA allows to specify multiple statements like import from JDBC.
This improvement permits parallelized data import from Oracle databases as the the import statements are executed in parallel on the Exasol database nodes.
Example:
import into ORA_TABLE from ORA at ORA_CONN STATEMENT 'select a,b,c from def where "c" = ''123'' ' STATEMENT 'select a2,b2,c2 from def where "e2" = ''456'' '
