Oracle Data Access Components, referred to as ODAC, is a powerful Oracle connection control package. Its main functions include the automatic upgrade of system data, support of Oracle objects, nesting of tables, sorting, pre-locking, etc., which can make Delphi easily access the Oracle database.
Oracle Data Access Components function 1. Establish the connection of Oracle data without publishing, installing, and configuring BDF and ODBC 2. No need to install Oracle software on the client. Just set the network and connect directly through TCP/IP 3. Extend Oracle data types, including XML style, LOB object, nested table, data information, time data, and time interval data 4. It has high performance when controlling the acquisition of a large number of data blocks 5. Optimize string and row data storage 6. Support Unicode encoded data 7. Automatically upgrade data through TSmartQuery and TOraTable components 8. Automatic record locking and refreshing 9. Non-block mode allows continuous background database queries to be run in several different threads 10. support Oracle 9i scroll pointer 11. Support a variety of Oracle features, such as warning, pipeline, and direct access interface 12. Separate the runtime and GUI into separate parts to establish a pure console program, such as CGI 13. the smart refresh option allows two or more data sets to be automatically synchronized 14. OraTools Add-in extends the functions of the design period, and establishes and blocks queries, designs, and debugs PL/SQL blocks, and probes database directories through complete sets of tools 15. extend SQL tracing function through TOraSQLMonitor component and DBMonitor program 16. TCRDBGrid source code is included, which improves the control of the grid unit where the data is located 17. extensive data display and report component support, including infopower, report builder, and fast report; 18. Support rapid migration from BDF to other databases