Read and write Oracle Database with no Oracle client
Maintainer(s):
krokozyab
Installing and Loading
INSTALL oracle_scanner FROM community;
LOAD oracle_scanner;
Added Functions
| function_name | function_type | description | comment | examples |
|---|---|---|---|---|
| oracle_arguments | table | NULL | NULL | |
| oracle_call | table | NULL | NULL | |
| oracle_call_auto | table | NULL | NULL | |
| oracle_call_cursors | table | NULL | NULL | |
| oracle_call_implicit | table | NULL | NULL | |
| oracle_call_inout_number | table | NULL | NULL | |
| oracle_call_inout_varchar | table | NULL | NULL | |
| oracle_call_named | table | NULL | NULL | |
| oracle_call_named_function | table | NULL | NULL | |
| oracle_call_number | table | NULL | NULL | |
| oracle_call_number_args | table | NULL | NULL | |
| oracle_call_out_number | table | NULL | NULL | |
| oracle_call_out_varchar | table | NULL | NULL | |
| oracle_close_call | table | NULL | NULL | |
| oracle_cursor | table | NULL | NULL | |
| oracle_execute | table | NULL | NULL | |
| oracle_execute_many | table | NULL | NULL | |
| oracle_query | table | NULL | NULL | |
| oracle_scan_parallel | table | NULL | NULL | |
| oracle_scanner_version | scalar | NULL | NULL |
Overloaded Functions
This extension does not add any function overloads.
Added Types
This extension does not add any types.
Added Settings
| name | description | input_type | scope | aliases |
|---|---|---|---|---|
| oracle_filter_pushdown | Send WHERE predicates on an attached Oracle table to Oracle. Only filters whose Oracle meaning is provably identical are translated; anything else raises. | BOOLEAN | GLOBAL | [] |
| oracle_session_pool_size | How many authenticated Oracle sessions one DuckDB connection keeps for reuse, per secret. 0 opens a fresh session for every statement. | BIGINT | GLOBAL | [] |