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 LOB


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


Database PL/SQL Language Reference, 11g Release 1 (11.1)

PL/SQL Data Types

Predefined PL/SQL Large Object (LOB) Data TypesLarge object (LOB) data types reference large objects that are stored separately from other data … items, such as text, graphic images, video clips, and sound waveforms. LOB data types allow efficient … , random, piecewise access to this data. Predefined PL/SQL LOB data types are listed and described in … Table 3-9. Table 3-9

Database Concepts, 11g Release 1 (11.1)

Oracle Data Types

LOB Character Datatypes… Implicit conversion between CHAR/VARCHAR2 and NCHAR/NVARCHAR2 is also supported. LOB Character Datatypes

Database Concepts, 11g Release 1 (11.1)

Oracle Data Types

Overview of LOB DatatypesThe LOB datatypes BLOB, CLOB, NCLOB, and BFILE enable you to store and manipulate large blocks of … you always use LOB datatypes over LONG datatypes. You can perform parallel queries (but not parallel … DML or DDL) on LOB columns. LOB datatypes differ from LONG and LONG RAW datatypes in several ways … . For example:

Database Utilities, 11g Release 1 (11.1)

SQL*Loader Concepts

Supported LOB TypesA LOB is a large object type. This release of SQL*Loader supports loading of four LOB types: BLOB … : a LOB containing unstructured binary data CLOB: a LOB containing character data NCLOB: a LOB … control file data definition language to load these LOB types

Database Utilities, 11g Release 1 (11.1)

Loading Objects, LOBs, and Collections

Loading LOB Data from LOBFILEsLOB data can be lengthy enough so that it makes sense to load it from a LOBFILE instead of from a … primary datafile. In LOBFILEs, LOB data instances are still considered to be in fields (predetermined … avoided. This type of organization of data is ideal for LOB loading. There is no requirement that a … LOB from

Pro*C/C++ Programmer's Guide, 11g Release 1 (11.1)

LOBs

LOB StatementsThe statements are presented alphabetically. In all the statements where it appears, database refers to a database connection

Pro*COBOL Programmer's Guide, 11g Release 1 (11.1)

Large Objects (LOBs)

LOB LocatorsA LOB locator points to the actual LOB contents. The locator is returned when you retrieve the LOB … , not the LOB's contents. LOB locators cannot be saved in one transaction or session and used again in a later transaction or session.

Data Provider for .NET Developer's Guide, 11g Release 1 (11.1)

LOB Support

LOB SupportODP.NET provides an easy and optimal way to access and manipulate large object (LOB) data types … Provider for.NET LOB Objects Updating LOBs Using a DataSet Updating LOBs Using OracleCommand and … OracleParameter Updating LOBs Using ODP.NET LOB Objects Temporary LOBs

Pro*C/C++ Programmer's Guide, 11g Release 1 (11.1)

New Features

LOB Supportthe LOB interface. See the chapter Chapter 16, \"LOBs\" for complete details.

Oracle Call Interface Programmer's Guide, 11g Release 1 (11.1)

LOB Functions

LOB FunctionsThis section describes the LOB functions which use the LOB locator. Use functions that end in \"2 … described in these sections: See Also: \"Binding LOB Data\" for usage and examples for both INSERT … and UPDATE statements \"Defining LOB Data\" for usage and examples of SELECT statements Chapter 7 … , \"LOB

Pro*COBOL Programmer's Guide, 11g Release 1 (11.1)

Large Objects (LOBs)

LOB StatementsThe statements are presented alphabetically. In all the statements where it appears, database refers to a database connection

Objects for OLE Developer's Guide, 11g Release 1 (11.1)

Tuning and Troubleshooting

LOB ErrorsTable 5-6 lists the LOB errors. Table 5-6 LOB Errors Constant Value Description … OERROR_INVSEEKPARAMS 4897 Invalid seek value is specified for the LOB read/write operation. OERROR_LOBREAD 4898 Read … operation is not byte. OERROR_INVLOBLEN 4902 Invalid buffer length for the LOB write operation … Invalid input

Oracle Call Interface Programmer's Guide, 11g Release 1 (11.1)

Datatypes

LOB DescriptorA LOB (Large Object) stores binary or character data up to 128 terabytes in length. Binary data is … stored in a BLOB (Binary LOB), and character data is stored in a CLOB (Character LOB) or NCLOB … (National Character LOB). LOB values may or may not be stored inline with other row data in the database

Pro*C/C++ Programmer's Guide, 11g Release 1 (11.1)

LOBs

LOB LocatorsA LOB locator points to the actual LOB contents. The locator is returned when you retrieve the LOB … , not the LOB's contents. LOB locators cannot be saved in one transaction or session and used again in a later transaction or session.

Oracle Call Interface Programmer's Guide, 11g Release 1 (11.1)

LOB Functions

OCILobCreateTemporary()Purpose Create a temporary LOB Syntax sword OCILobCreateTemporary(OCISvcCtx *svchp, OCIError *errhp

Oracle Call Interface Programmer's Guide, 11g Release 1 (11.1)

LOB Functions

svchp (IN)LOB. You must allocate the locator using OCIDescriptorAlloc() before passing it to this function … . It does not matter whether or not this locator already points to a LOB, it will get overwritten … either way. csid (IN) The LOB character set ID. For Oracle8 i or later, pass as OCI_DEFAULT. csfrm (IN … ) The LOB

Oracle Call Interface Programmer's Guide, 11g Release 1 (11.1)

LOB Functions

OCILobErase()Purpose Erases a specified portion of the internal LOB data starting at a specified offset. Syntax

Oracle Call Interface Programmer's Guide, 11g Release 1 (11.1)

LOB Functions

svchp (IN)is called for an internal LOB. No error is returned if the BFILE exists but is not opened. This

Oracle Call Interface Programmer's Guide, 11g Release 1 (11.1)

LOB Functions

svchp (IN/OUT)the LOB. flag (IN) When set to OCI_LOB_BUFFER_FREE, the buffer resources for the LOB are freed after … subsystem that are associated with the LOB referenced by the input locator. This routine will actually … write the data in the buffer to the LOB in the database. LOB buffering must have already been

Oracle Call Interface Programmer's Guide, 11g Release 1 (11.1)

LOB Functions

For BFILEsassociated with the LOB, not with the locator. If locator1 opened the LOB then locator2 also sees the LOB … server to see if the LOB is indeed open. For external LOBs ( BFILEs ), this call also requires a