OCI supports all SQL data definition, data manipulation, query, and transaction control facilities that are available through an Oracle database. The combination of both nonprocedural and procedural language elements in an OCI program provides easy access to an Oracle database in a structured programming environment. The procedural nature of these languages makes them more complex than SQL, but it also makes them more flexible and powerful. In a procedural language program, the execution of most statements depends on previous or subsequent statements and on control structures, such as loops or conditional branches, that are not available in SQL. It is also the standard language used to access and manipulate data in modern relational and object-relational database systems. The nonprocedural nature of SQL makes it an easy language to learn and to use to perform database transactions. In a nonprocedural language program, the set of data to be operated on is specified, but what operations are to be performed, or how the operations are to be conducted, is not specified. OCI enables you to develop scalable, multithreaded applications in a multitier architecture that combines the nonprocedural data access power of structured query language (SQL) with the procedural capabilities of C and C++. Thread safety, which eliminates the need for mutual exclusive locks (mutexes) on OCI handles
Optimization of queries using transparent prefetch buffers to reduce round-trips Use of familiar third-generation language programming techniques and application development tools, such as browsers and debuggersĬonnection pooling, session pooling, and statement caching that enable building of scalable applicationsĪvailability on the broadest range of operating systems of all the Oracle programmatic interfacesĭynamic binding and defining using callbacksĭescription functionality to expose layers of server metadataĪsynchronous event notification for registered client applicationsĮnhanced array data manipulation language (DML) capability for array inserts, updates, and deletesĪbility to associate commit requests with executes to reduce round-trips High degree of control over program execution More fine-grained control over all aspects of application design OCI provides significant advantages over other methods of accessing an Oracle Database: OCI extensions to support client-side access to Oracle objects
#PL SQL DEVELOPER 11.0.4 PASSWORD#
Simplified user authentication and password managementĮxtensions to improve application performance and scalabilityĬonsistent interface for transaction management OCI has many new features that can be categorized into several primary areas:Įncapsulated or opaque interfaces, whose implementation details are unknown See Oracle TimesTen In-Memory Database C Developer's Guide. You can use OCI to access Oracle TimesTen In-Memory Database and Oracle In-Memory Database Cache.
It provides a library of standard database access and retrieval functions in the form of a dynamic runtime library (OCI library) that can be linked in an application at run time. OCI enables you to manipulate data and schemas in an Oracle Database using the C programming language. Improved performance and scalability through the efficient use of system memory and network connectivityĬonsistent interfaces for dynamic session and transaction management in a two-tier client/server or multitier environmentĬomprehensive support for application development using Oracle Database objectsĪpplications that support an increasing number of users and requests without additional hardware investments Oracle C++ Call Interface Programmer's Guide
0 kommentar(er)
