本地连接Oracle

基于ODAC的数据库部署简单，无需安装其他数据提供层（如BDE或ODBC）。因此，它比基于standard Delphi data 的连接方案要快。此外，ODAC可以直接通过TCP/ IP与Oeacle协作，不用经过Oracle客户端。

支持大部分Oracle功能

ODAC支持大部分的Oracle功能，如DML矩阵、REF游标、对象、包、直接加载路径、提示、Pipes、高级矩阵、 透明应用故障切换，等等。

Delphi、C++Builder和Lazarus的跨平台解决方案

ODAC是一个跨平台的解决方案，用于各种集成开发环境：RAD Studio、 Delphi,、C++Builder、 Lazarus (and FPC) on Windows、Mac OS X、iOS、 Android、 Linux和FreeBSD（x86、x64）。ODAC还支持FireMonkey应用开发平台，可以开发可视化高性能的台式机和移动原生应用程序。

高效率开发

ODAC提供了很多GUI工具，大大提高您的工作效率。dbMonitor可以监测数据库应用程序的活动；Dataset Manager简化了数据集和DB控制调整；OraDeveloper工具简化了探索和维护现有的数据块，设计和查询SQL复合语句以及处理数据。

关键特性

直接模式

移动开发

DB兼容性

数据类型映射

IDE兼容性

开发平台

性能

监控

支持

Components
All editions of ODAC include the following basic components:

• TOraSession - lets you set up and control connections to Oracle
• TOraQuery - executes queries, operates record set, provides flexible way updating database tables with automatically building INSERT, DELETE, UPDATE statements
• TSmartQuery - easy in using traffic-efficient alternative to TOraQuery for working with large tables with lots of fields, includes Smart Refresh functionality in Professional and Developer Editions
• TOraTable - lets you retrieve and update data in a single table without writing SQL statements
• TOraStoredProc - executes stored procedures and functions, allows to edit cursor data returned as parameter
• TOraSQL - executes SQL statements, PL/SQL blocks, stored procedures
• TOraScript - executes sequences of SQL and PL/SQL statements
• TOraUpdateSQL - lets you tune update operations for a DataSet component
• TOraNestedTable - controls nested table's data
• TOraDataSource - provides an interface for connecting data-aware controls on a form and ODAC dataset components
• TOraSQLMonitor - allows to monitor dynamic SQL executing in ODAC based applications
• TConnectDialog - allows you to build custom prompts for usernames, passwords, and server names
• TVirtualTable - provides dataset functionality for data that has no real database connection
• OraDataAdapter - .NET component, uses TDataSet as data source for retrieving and saving data to System.Data.DataSet

ODAC Professional Edition and ODAC Developer Edition include the following additional components:

• TOraPackage - provides a straightforward way to access Oracle packages
• TOraLoader - allows you to quickly load data into Oracle databases
• TOraAlerter - allows you to transfer messages between sessions
• TOraTransaction - provides discrete transaction control over sessions, can be used to manipulate both simple and distributed transactions
• TOraQueue - lets you monitor the message queue, provides an interface for enqueuing and dequeuing messages
• TOraQueueTable - manages queue tables
• TOraQueueAdmin - manages Oracle queues
• TOraChangeNotification - allows you to use Oracle Database Change Notifications
• TOraTrace - allows you to start and stop the SQL trace for a specified session
• TOraErrorHandler - translates error messages
• TBDESession - allows to integrate ODAC components into BDE based application
• TOraMetaData - retrieves metadata on specified SQL object
• TOraProvider - provides data to and applies updates from a client dataset
• TCRBatchMove - transfers data between all types of TDataSet descendants

Key Features
The following list describes the main features of Oracle Data Access Components.

• Direct access to server data. Does not require installation of other data provider layers (such as BDE and ODBC)
• In Direct mode does not require Oracle client software and works directly through TCP/IP
• VCL, VCL.NET, and CLX versions of library available
• Full support of the latest versions of Oracle
• Support for all Oracle data types
• Disconnected Model with automatic connection control for working with data offline
• Local Failover for detecting connection loss and implicitly re-executing certain operations
• Oracle Transparent Application Failover support
• All types of local sorting and filtering, including by calculated and lookup fields
• Automatic data updating with TOraQuery, TSmartQuery, and TOraTable components
• Unicode and national charsets support
• Distributed transaction support
• Oracle Advanced Queuing support
• Support for many Oracle-specific features, such as alerts, pipes and direct path interface
• Advanced script execution functionality with TOraScript component
• Support for using Macros in SQL
• Integration with OraDeveloper Tools for performing advanced database development and administration tasks
• Easy migration from BDE with Migration Wizard
• Lets you use Professional Edition of Delphi, C++Builder, and Kylix to develop client/server applications
• Includes annual ODAC Subscription with Priority Support
• Licensed royalty-free per developer, per team, or per site