Features

The Oracle ODBC Driver enables applications to connect to Oracle database from a Windows client as well as from a UNIX client that use Microsoft Open Database Connectivity (ODBC) API to read from and write to Oracle databases.
The Oracle JDBC driver class that implements the java.sql.Driver interface. Register the JDBC drivers To access a database from a Java application, you must first provide the code to register your installed driver with your program.

Easily installed from PyPI.
Support for Python 3.6 and higher. Older versions of cx_Oracle may be used with previous Python releases.
Support for Oracle Client 11.2, 12, 18, 19 and 21. Oracle's standard cross-version interoperability, allows easy upgrades and connectivity to different Oracle Database versions.
Connect to Oracle Database 9.2, 10, 11, 12, 18, 19 or 21 (depending on the Oracle Client version used).
SQL and PL/SQL Execution. The underlying Oracle Client libraries have significant optimizations including compressed fetch, pre-fetching, client and server result set caching, and statement caching with auto-tuning.
Full use of Oracle Network Service infrastructure, including encrypted network traffic and security features.
Extensive Oracle data type support, including large object support (CLOB and BLOB).
Direct binding to SQL objects. One great use case is binding Python objects to Oracle Spatial SDO objects.
SODA (Simple Oracle Document Access)
Array operations for efficient INSERT and UPDATEs.
Skyhawke network & wireless cards driver download for windows. Array row counts and batch error handling for array operations.
Fetching of large result sets.
REF CURSOR support.
Support for scrollable cursors. Go back and forth through your query results.
Fetch PL/SQL Implicit Results. Drivers prosa. Easily return query results from PL/SQL.
Row Prefetching. Efficient use of the network.
Client Result Caching. Improve performance of frequently executed look-up statements.
Support for Advanced Queuing. Use database notifications to build micro-service applications.
Continuous Query Notification (CQN). Get notified when data changes.
Support for Edition Based Redefinition. Easily switch applications to use updated PL/SQL logic.
Support for setting application context during the creation of a connection, making application metadata more accessible to the database, including in LOGON triggers.
End-to-end monitoring and tracing.
Download Pace Anti-piracy driver. Transaction Management.
Session Pooling, with tagging and session state fix-up callback.
Database Resident Connection Pooling (DRCP).
Privileged Connections.
External Authentication.
Database startup and shutdown.
Sharded Databases.
Oracle Database High Availability Features, such as FAN notifications and Transaction Guard support.

DB API specification exclusions: The time data type is not supported by Oracle and is therefore not implemented. The method cursor.nextset() is not implemented either as the DB API specification assumes an implementation of cursors that does not fit well with Oracle's implementation of cursors and implicit results. See the method cursor.getimplicitresults() for more information.

-->

Important

This feature will be removed in a future version of Windows. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Instead, use the ODBC driver provided by Oracle.

You can control performance of the ODBC Driver for Oracle by knowing the data environment and correctly setting the parameters of the data source connection through the ODBC Data Source Administrator dialog box or through connect string parameters. The dialog box provides the following controls for connecting to a data source using the dialog box or using connect strings:

This is an Oracle database driver for Rust based on ODPI-C. Applications using Rust-oracle 0.1.x should use 0.2.x. The incompatibility between 0.1.x and 0.2.x is trivial so they will work well without modification. The author continues updating 0.2.x to fix bugs as long as it doesn't introduce incompatibilities. The driver is optimized to communicate directly and efficiently with Oracle servers using the Oracle server wire protocol. Our ODBC Driver for Oracle also fully supports all Oracle systems including Oracle 8.1.5 and higher from a single wire protocol ODBC driver. When configuring the driver for use with database/sql, keep in mind that database/sql has strict Go type-to-Oracle type mapping expectations. Working With The Oracle Package Directly The ora package allows programming with pointers, slices, nullable types, numerics of various sizes, Oracle-specific types, Go return type configuration, and Oracle abstractions such as environment, server and session.

User DSN tab Lists the Data Source Names that are local to the computer.
System DSN tab Enables you to add or remove a system data source. System data sources can be accessed by all users on the local computer.
File DSN tab Enables you to add or remove a file data source from the local computer. File data sources can be shared by all users who have the same driver installed.
Drivers tab Lists the installed ODBC drivers.
Tracing tab Enables you to specify how the ODBC Driver Manager traces calls to ODBC functions. You can configure tracing separately for each installed ODBC application.
Connection Pooling tab Enables you to select connection options for each installed driver.
About tab Lists the installed ODBC component files.

Oracle Driver Maven

After you add a data source, you can use the ODBC Data Source Administrator dialog box to configure the access to your data source. Select a data source, and then click one of the tabs to edit or review the information.