ODAC (V9.5.15) Learning notes (ii) List of controls

There are 26 ODAC controls, briefly described below:

Torasession managing connections to Oracle
toraquery using SQL for data acquisition, automatically submitting updates to the database
tsmartquery A query control that is more efficient when you are working with a large table that has few fields and records more.
torasql SQL statement execution controls, including PL/SQL blocks, do not return dataset results
toratable controls for single-table operations
Torastoredproc Stored procedure controls that allow you to edit cursor data and return it as a parameter
toranestedtable Managing nested tables for Oracle
Toraupdatesql SQL statements that centrally manage data updates and their execution
Toradatasource Override system default Tdatasource data source control
torascript script Management and execution controls
torasqlmonitor SQL Trace Control
tconnectdialog Connection dialog box, not very useful
tvirtualtable the Memory Table control,
Toraencryptor controls for decrypting data
Torapackage Package Management controls
Toraalerter Message control, passing messages between sessions
Toraloader can quickly import data into controls in an Oracle database
toratransaction database Transaction management controls, which can be used to manage distributed transactions
toraqueue Oracle Queue management Controls
toraqueuetable
Toraqueueadmin
torachangenotification Oracle Database Change message notification control
Toratrace A control that makes a SQL trace on a thread
Toraerrorhandler handling of Oracle Error controls
Toraprovider Replacement system default Tdatasetprovider
tbdesession-compatible BDE program controls
Torametadata Control to obtain Oracle object information
Tcrbatchmove A control that replicates data between datasets (Tdataset) and deletes them.

ODAC (V9.5.15) Learning notes (ii) List of controls