OCI demo整理
最近学习Oracle 官方文档中的OCI。 发现找不到官方文档提供的DEMO。
以下内容来自: http://docs.oracle.com/cd/E11882_01/appdev.112/e10646/ociabdem.htm#LNOCI280
You must install the demonstration programs as described in Oracle Database Examples Installation Guide. The location, names, and availability of the programs may vary on different operating systems. On a Linux or UNIX workstation, the programs are installed in the $ORACLE_HOME/rdbms/demo directory. For Windows systems, see Appendix D.
可是$ORACLE_HOME/rdbms/demo 下并没有实例，通过查阅各方资料， 现将11gR2的demo整理如下：
参考资料： https://stackoverflow.com/questions/6331024/does-oracle-really-offer-any-oci-demo-sample-programs
实例下载地址： http://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_examples.zip
Downloads\linux.x64_11gR2_examples.zip\examples\stage\Components\oracle.rdbms.companion\11.2.0.1.0\1\DataFiles\filegroup2.jar\rdbms\demo\
我共享的demo文件： http://pan.baidu.com/s/1i5xcdDj
以下内容来自: http://docs.oracle.com/cd/E11882_01/appdev.112/e10646/ociabdem.htm#LNOCI280
You must install the demonstration programs as described in Oracle Database Examples Installation Guide. The location, names, and availability of the programs may vary on different operating systems. On a Linux or UNIX workstation, the programs are installed in the $ORACLE_HOME/rdbms/demo directory. For Windows systems, see Appendix D.
可是$ORACLE_HOME/rdbms/demo 下并没有实例，通过查阅各方资料， 现将11gR2的demo整理如下：
参考资料： https://stackoverflow.com/questions/6331024/does-oracle-really-offer-any-oci-demo-sample-programs
实例下载地址： http://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_examples.zip
Downloads\linux.x64_11gR2_examples.zip\examples\stage\Components\oracle.rdbms.companion\11.2.0.1.0\1\DataFiles\filegroup2.jar\rdbms\demo\
我共享的demo文件： http://pan.baidu.com/s/1i5xcdDj
| Program Name | Features Illustrated |
| cdemo81.c | Using basic SQL processing with release 8 functionality |
| cdemo82.c | Performing basic processing of user-defined objects |
| cdemocor.c | Using complex object retrieval (COR) to improve performance |
| cdemodr1.c | Using INSERT, UPDATE, and DELETE statements, with RETURNING |
| cdemodr2.c | clause used with basic data types, LOBs and REFs |
| cdemodr3.c | clause used with basic data types, LOBs and REFs |
| cdemodsa.c | Describing information about a table |
| cdemodsc.c | Describing information about an object type |
| cdemofo.c | Registering and operating application failover callbacks |
| cdemolb.c | Creating and inserting LOB data and then reading, writing, coping,appending, and triming the data |
| cdemolb2.c | Writing and reading of CLOB and BLOB columns with stream mode and callback functions |
| cdemolbs.c | Writing and reading to LOBs with the LOB buffering system |
| cdemobj.c | Pinning and navigation of REF object |
| cdemocoll.c | Inserting and selecting of nested table and varray |
| cdemorid.c | Using INSERT, UPDATE, DELETE statements and fetches to get multiple rowids in one round-trip |
| cdemoses.c | Using session switching and migration |
| cdemothr.c | Using the OCIThread package |
| cdemosyev.c |
Registering predefined subscriptions and specifying a callback function to be invoked for client notifications (for more information about to be invoked for client notifications (for more information about |
| ociaqdemo00.c | Streams Advanced Queuing. Enqueues 100 messages |
| ociaqdemo01.c | Dequeues messages by blocking |
| ociaqdemo02.c | Listens for multiple agents |
| ociaqarrayenq.c | Array enqueue of 10 messages |
| ociaqarraydeq.c | Array dequeue of 10 messages |
| cdemodp.c | Loading data with the direct path load functions |
| cdemodp_lip.c | Loading data with the direct path load functions |
| cdemdpco.c | Loading a column object with the direct path load functions |
| cdemdpno.c | Loading a nested column object with the direct path load functions |
| cdemdpin.c | Loading derived type (inheritance) - direct path |
| cdemdpit.c | Loading an object table with inheritance - direct path |
| cdemdpro.c | Loading a reference with the direct path load functions |
| cdemdpss.c | Loading SQL strings with the direct path load functions |
| cdemoucb.c | Using static and dynamic user callbacks |
| cdemoucbl.c | Using static and dynamic user callbacks |
| cdemoupk.c | Using dynamic user callbacks with multiple packages |
| cdemoup1.c | Using dynamic user callbacks with multiple packages |
| cdemoup2.c | Using dynamic user callbacks with multiple packages |
| cdemodt.c | Datetime and interval example. Demonstrates IN and OUT binds with PL/SQL procedure or function |
| cdemosc.c | Scrollable cursor |
| cdemol2l.c | Accesses LOBs using the LONG API (Data Interface) |
| cdemoin1.c | Inheritance demo that modifies an inherited type in a table and displays a record from the table |
| cdemoin2.c | Inheritance demo to do attribute substitutability |
| cdemoin3.c | Inheritance demo that describes an object, inherited types, object tables, and a sub-table |
| cdemoanydata1.c | Anydata demo. Inserts and selects rows to and from anydata table |
| cdemoanydata2.c | Anydata demo. Creates a type piecewise using OCITypeBeginCreate() and then describes the new type created |
| cdemoqc.c | Query caching using SQL hints |
| cdemoqc2.c | Query caching using SQL hints and table annotation |
| cdemosp.c | Session pooling |
| cdemocp.c | Connection pooling |
| cdemocpproxy.c | Connection pooling with proxy functionality |
| cdemostc.c | Statement caching |
| cdemouni.c | Program for OCI UTF16 API |
| nchdemo1.c | Shows NCHAR implicit conversion feature and code point feature |
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29654587/viewspace-2141537/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
