xvii
List of Examples
3–1 How to Define a DataStream Datatype ................................................................................... 3-1
3–2 How to Define the Type Body................................................................................................... 3-2
3–3 How to Specify an ODI for an Object Type............................................................................. 3-3
3–4 How to Assign and Use OIDs................................................................................................... 3-3
3–5 How to Create a Type................................................................................................................. 3-4
3–6 How to Instantiate a Type Object ............................................................................................. 3-4
3–7 How to Implement a Member Function.................................................................................. 3-4
3–8 How to Implement Functions for Types Without a Simple Id Attributte .......................... 3-4
4–1 How to Define an Object Type.................................................................................................. 4-1
4–2 How to Define a "Greatest Common Divisor" Function ....................................................... 4-2
4–3 How to Implement Methods for an Object Type ................................................................... 4-2
4–4 How to Invoke Methods; General Syntax ............................................................................... 4-3
4–5 How to Invoke Methods; SQL Syntax...................................................................................... 4-3
4–6 How to Invoke Methods; General Syntax ............................................................................... 4-3
4–7 How to use the SELF Build-In Paramenter ............................................................................. 4-3
4–8 How to Set Variable Values....................................................................................................... 4-3
4–9 How to Create a Package Specification ................................................................................... 4-4
4–10 How to Assert the Purity Level of a Type............................................................................... 4-5
4–11 How to Assert the Purity Level of a Package ......................................................................... 4-5
4–12 How to Assert a Default Purity Level for All Type Methods and Package Procedures .. 4-5
4–13 How to Output Variable Values to the Terminal, for Debugging....................................... 4-6
5–1 How to Create an Alias Library................................................................................................ 5-2
5–2 How to Specify the Location of the Library Using an Environment Variable................... 5-2
5–3 How to Define the Body of a Package ..................................................................................... 5-2
5–4 How to Set the SID_DESC Entry in the Listener Configuration FIle .................................. 5-4
5–5 How to Update the Network Substrate Configuration File to Refer to External Procedures .
5-5
5–6 How to Use Callbacks ................................................................................................................ 5-8
6–1 How to Create a CLOB Attribute of a Type............................................................................ 6-2
6–2 How to Create a LOB Object Table...........................................................................................
6-2
6–3 How to Create LOB Columns in a Table................................................................................. 6-2
6–4 How to Select a LOB Locator and Assign it to a Local Variable.......................................... 6-2
6–5 How to Manipulate LOBs with PUT_LINE and GETLENGTH .......................................... 6-3
6–6 Syntax of EMPTY_CLOB() and EMPTY_CLOB() Functions ................................................ 6-3
6–7 How to Use EMPTY_BLOB() with SQL DML ........................................................................ 6-4
6–8 How to Use EMPTY_CLOB() in PL/SQL Programs ............................................................. 6-4
6–9 How to Select a LOB from the Database into a Locator........................................................ 6-6
6–10 How to Trim a CLOB.................................................................................................................. 6-8
6–11 How to Define a PL/SQL External Procedure ....................................................................... 6-8
6–12 How to Use Open and Close Code Block............................................................................. 6-10
8–1 How to Create an Indextype ..................................................................................................... 8-6
8–2 How to Comment an INDEXTYPE .......................................................................................... 8-7
8–3 How to Create a Domain Index ................................................................................................ 8-8
8–4 How to Get the Size of a UROWID Column........................................................................... 8-9
8–5 How to Use *_SECONDARY_OBJECTS Views................................................................... 8-12
8–6 How to Use a Local Domain Index Methods Within an Indextype ................................. 8-14
8–7 How to Create and Partition an Index.................................................................................. 8-14
8–8 How to Create a Local Domain Index................................................................................... 8-14
8–9 How to Create a System-Partitioned Table.......................................................................... 8-17
8–10 How to Insert Data into a System-Partitioned Table.......................................................... 8-18
8–11 How to Insert Data into a System-Partitioned Table Using DATAOBJ_TO_PARTITION......
8-18
9–1 How to Create an Operator....................................................................................................... 9-2
9–2 How to Drop an Operator; RESTRICT Option....................................................................... 9-2
我的内容管理
展开
