You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for FROM


1 to 20 of 16344 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Pro*PL/I Supplement to the Oracle Precompilers Guide, 9i Release 2 (9.2.0.2)

Differences from Previous Release

A Differences from Previous ReleaseThis appendix lists differences between Pro*PL/I precompiler release 1.5 and 1.6. Each feature modification is followed by one or more page numbers referencing the relevant section in this Manual. Bold page numbers refer to the section with the main description of the feature.

Pro*PL/I Supplement to the Oracle Precompilers Guide, 9i Release 2 (9.2.0.2)

Differences from Previous Release

TopicsConfiguration files 3-3, 3-4 DBMS Option 1-13, 1-15, 3-5 INLINE option 3-2 MODE Option 1-13, 3-7 sqlglm() 2-15 SQLSTATE variable 1-7, 2-2   Copyright © 1996-2001 Oracle Corporation. All Rights Reserved. Home Book List Contents Index Master Index Feedback

Application Developer's Guide - Large Objects, 9i Release 2 (9.2.0.2)

Migrating From LONGs to LOBs

Migrating Existing Tables from LONG to LOBThis section describes techniques for migrating existing tables from LONG to LOB datatypes.

Application Developer's Guide - Large Objects, 9i Release 2 (9.2.0.2)

Migrating From LONGs to LOBs

Using OCI Functions to Perform INSERT or UPDATE on LOBsThere are various ways to perform INSERT or UPDATE of LOB data. Note: These are in addition to the ways to insert LOB locators, which are documented in Chapter 10, "Internal Persistent LOBs". In all the ways described in the following, it is assumed that you have initialized the OCI environment and allocated all necessary handles. Simple INSERTs or UPDATEs in One Piece To perform simple INSERTs and

Application Developer's Guide - Large Objects, 9i Release 2 (9.2.0.2)

Migrating From LONGs to LOBs

Explicit Conversion FunctionsIn PL/SQL, the following two new explicit conversion functions have been added to convert other data types to CLOB and BLOB as part of LONG-to-LOB migration: TO_CLOB() converts LONG, VARCHAR2, and CHAR to CLOB TO_BLOB() converts LONG RAW and RAW to BLOB TO_CHAR() is enabled to convert a CLOB to a CHAR type.

Application Developer's Guide - Large Objects, 9i Release 2 (9.2.0.2)

Migrating From LONGs to LOBs

Calling PL/SQL and C Procedures from SQL or PL/SQLFrom SQL When a PL/SQL procedure is called from SQL, LONG parameters are not allowed. So this case … is not a part of the LONG-to-LOB conversion process. From PL/SQL You can call a PL/SQL or C … procedure from PL/SQL. It is possible to pass a CLOB as an actual parameter where CHR is the formal

Application Developer's Guide - Large Objects, 9i Release 2 (9.2.0.2)

Migrating From LONGs to LOBs

Overloading with Anchored TypesFor applications using anchored types, some overloadings would silently resolve to different targets during the conversion to LOBs. For example: procedure p(l long) is...; -- (1) procedure p(c clob) is...; -- (2) Consider the caller: declare var longtab.longcol%type; begin... p(var);... end; Prior to LOB migration this call would have resolved to overload (1). Once longtab is migrated to LOBs this

Application Developer's Guide - Large Objects, 9i Release 2 (9.2.0.2)

Migrating From LONGs to LOBs

Using utldtree.sql to Determine Where Your Application Needs Changecases documented in the section titled "Applications Requiring Changes When Converting From LONGs to

Application Developer's Guide - Large Objects, 9i Release 2 (9.2.0.2)

Migrating From LONGs to LOBs

Examples of Converting from LONG to LOB Using Table Multimedia_tab"Applications Requiring Changes When Converting From LONGs to LOBs".

Application Developer's Guide - Large Objects, 9i Release 2 (9.2.0.2)

Migrating From LONGs to LOBs

Converting LONG to LOB Example 4: Array insertThe following example illustrates converting from LONG to LOBs when using an array INSERT: word

Application Developer's Guide - Large Objects, 9i Release 2 (9.2.0.2)

Migrating From LONGs to LOBs

Converting LONG to LOB Example 6: Piecewise Fetch with PollingThe following example illustrates converting from LONG to LOBs when using a piecewise fetch with … polling: text *selstmt = (text *) "SELECT STORY FROM MULTIMEDIA_TAB ORDER BY CLIP_ID"; OCIStmtPrepare

Application Developer's Guide - Large Objects, 9i Release 2 (9.2.0.2)

Migrating From LONGs to LOBs

Converting LONG to LOB Example 9: Using PL/SQL in INSERT, UPDATE and SELECTStory INTO story_buffer FROM Multimedia_tab WHERE Clip_ID = 1; END;

Application Developer's Guide - Large Objects, 9i Release 2 (9.2.0.2)

Migrating From LONGs to LOBs

Converting LONG to LOB Example 12: Using PL/SQL Binds from OCI on LOBsThe LONG-to-LOB API allows LOB PL/SQL binds from OCI to work as follows: When you call a PL/SQL … procedure from OCI, and have an in or out or inout bind, you should be able to bind a variable as

Application Developer's Guide - Large Objects, 9i Release 2 (9.2.0.2)

Migrating From LONGs to LOBs

Triggers in LONGs and LOBsQuestion In Triggers, some functionality is supported for LONGs that is not supported for LOBs. Will this cause a problem? Answer There are a couple of limitations on how LOBs work with triggers. See "LONG-to-LOB Migration Limitations". Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. Home Book List Contents Index Master Index Feedback

Administrator's Guide, 9i Release 2 (9.2.0.2)

Migrating Data from Other Directories

About the Data Migration ProcessYou can import data from a third-party LDAP-compliant directory into Oracle Internet Directory by … must remove this extraneous data from the LDIF file before you import the file into Oracle Internet

Administrator's Guide, 9i Release 2 (9.2.0.2)

Migrating Data from Other Directories

Tasks For Migrating Data from Application-Specific Repositoriescertain substitution variables by searching the directory To migrate data from application-specific … bold text are supplied from the application-specific repository. dn: cn=UserID, %s_UserContainerDN … application passes the arguments to the OID Migration Tool, or the tool retrieves them from the directory … data listed in bold

Application Developer's Guide - Large Objects, 9i Release 2 (9.2.0.2)

Migrating From LONGs to LOBs

8 Migrating From LONGs to LOBsLONG-to-LOB API Migrating Existing Tables from LONG to LOB LONG-to-LOB Migration Limitations Using … When Converting From LONGs to LOBs Using utldtree.sql to Determine Where Your Application Needs … Change Examples of Converting from LONG to LOB Using Table Multimedia_tab Summary of New Functionality

Application Developer's Guide - Large Objects, 9i Release 2 (9.2.0.2)

Migrating From LONGs to LOBs

Implicit Conversion of NUMBER, DATE, ROW_ID, BINARY_INTEGER, and PLS_INTEGER to LOB is Not SupportedLONG. There are no plans to support implicit conversions from these types to LOB (explicit or implicit

Application Developer's Guide - Large Objects, 9i Release 2 (9.2.0.2)

Migrating From LONGs to LOBs

Converting LONG to LOB Example 3: Piecewise INSERT with CallbackThe following example illustrates converting from LONG to LOBs when using a piecewise INSERT with

Application Developer's Guide - Large Objects, 9i Release 2 (9.2.0.2)

Migrating From LONGs to LOBs

SQL StatementsThe following new syntax has been added: ALTER TABLE [.] MODIFY ( { CLOB | BLOB | NCLOB } [DEFAULT ) [LOB_storage_clause]; See "Migrating LONGs to LOBs: Using ALTER TABLE to Change LONG Column to LOB Types", for details. Changes made to the ALTER TABLE syntax are as follows: The "datatype" can now be: (CLOB|NCLOB) if the original datatype of the "long_column_name" was LONG (BLOB) if the original