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 CLOB


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


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

Datatypes

CLOB DatatypeThe CLOB datatype stores single-byte and multibyte character data. Both fixed-width and variable … -width character sets are supported, and both use the database character set. CLOB objects can store up … - 1) * (database block size). CLOB objects have full transactional support. Changes made through … SQL, the DBMS_LOB package,

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

PL/SQL Data Types

CLOB Data TypeYou use the CLOB data type to store large blocks of character data in the database, inline or out … -of-line. Both fixed-width and variable-width character sets are supported. Every CLOB variable stores … a locator, which points to a large block of character data. CLOB s participate fully in … rolled back. CLOB

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

Clob Class

Clob()Clob class constructor. Syntax Description Clob(); Creates a NULL Clob object. Clob( const … Connection *connectionp); Creates an uninitialized Clob object. Clob( const Clob *srcClob); Creates a copy … of a Clob object. Parameter Description connectionp

Database Concepts, 11g Release 1 (11.1)

Oracle Data Types

CLOB and NCLOB DatatypesThe CLOB and NCLOB datatypes store up to 128 terabytes of character data in the database. CLOB s … provide efficient character-based random access on CLOBs and NCLOBs. CLOB s and NCLOB s participate … fully in transactions. Changes made to a CLOB or NCLOB value by the DBMS_LOB package, PL/SQL, or the OCI … can

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

Clob Class

getStream()Returns a Stream object from the CLOB. If a stream is already open, it is disallowed to open … another stream on CLOB object, so the user must always close the stream before performing any Clob object … reading data from the CLOB. If offset is not specified, the data is written from the beginning of the … CLOB.

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

Clob Class

length()Returns the number of characters in the CLOB. Syntax unsigned int length() const;

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

Clob Class

operator=()Assigns a CLOB to the current CLOB. The source CLOB gets copied to the destination CLOB only when … the destination CLOB gets stored in the table. Syntax Clob& operator=( const Clob &srcClob … ); Parameter Description srcClob The Clob from which the

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

Clob Class

read()Reads a part or all of the CLOB into a buffer. Returns the actual number of characters read for … offset=1) const; Reads a part or all of the CLOB into a buffer. unsigned int read( unsigned int amt … CLOB into a buffer; globalization enabled. Should be called after setting character set to OCCIUTF16 … be read. from the CLOB.

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

Clob Class

trim()Truncates the CLOB to the new length specified. Syntax void trim( unsigned int newlen); Parameter … Description newlen The new length of the CLOB. Valid values are numbers less than or equal to the current length of the CLOB.

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

Clob Class

setOptions()not configured on the database column or partition that stores the CLOB. Will throw an exception if … attempting to turn off encryption in an encrypted CLOB column. Syntax void setOptions( LobOptionType

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

Clob Class

writeChunk()Writes data from a buffer into a previously opened CLOB. The actual number of characters written is … from a buffer into a previously opened CLOB. unsigned int writeChunk( unsigned int amt, utext … *buffer, unsigned int bufsize, unsigned int offset=1); Writes data from a UTF16 buffer into a CLOB … UTF8) buffer The buffer containing

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

Clob Class

close()Closes a CLOB. Syntax void close();

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

Clob Class

getChunkSize()Returns the smallest data size to perform efficient writes to the CLOB. Syntax unsigned int getChunkSize() const;

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

Clob Class

Method SummaryClob() Clob class constructor. append() Appends a Clob at the end of the current Clob. close … () Closes a previously opened Clob. closeStream() Closes the Stream object obtained from the current Clob … . copy() Copies all or a portion of a Clob or BFILE into the current

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

Clob Class

append()Appends a CLOB to the end of the current CLOB. Syntax void append( const Clob &srcClob); Parameter … Description srcClob The CLOB to be appended to the current CLOB.

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

Clob Class

getOptions()Returns the CLOB 's LobOptionValue for a specified LobOptionType. Will throw an exception if … that stores the CLOB. Syntax LobOptionValue getOptions( LobOptionType optType); Parameter Description

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

Clob Class

isInitialized()Tests whether the Clob object is initialized. If the Clob object is initialized, TRUE is returned

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

Clob Class

setCharSetId()Sets the Character set Id associated with Clob. The characterset id set will be used for read/write

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

Clob Class

setCharSetIdUString()Sets the Character set Id associated with Clob. used when the environment's characterset is UTF16

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

Clob Class

setCharSetForm()Sets the character set form associated with the CLOB. The charset form set will be used for read … be used. Syntax void setCharSetForm( CharSetForm csfrm ); Parameter Description csfrm The charset form for Clob.

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

Clob Class

Clob ClassThe Clob class defines the common properties of objects of type CLOB. A Clob is a large character … object stored as a column value in a row of a database table. A Clob object contains a logical … pointer to a CLOB, not the CLOB itself. Methods of the Clob class enable

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

Clob Class

operator==()Compares two Clob objects for equality. Two Clob objects are equal if they both refer to the same … CLOB. Two NULL Clob objects are not considered equal. If the Blob objects are equal, then TRUE is … returned; otherwise, FALSE is returned. Syntax bool operator==( const Clob &srcClob) const; Parameter

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

Clob Class

setNull()Sets the Clob object to atomically NULL. Syntax void setNull();

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

Clob Class

closeStream()Closes the Stream object obtained from the CLOB. Syntax void closeStream( Stream *stream

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

Clob Class

copy()Copies a part or all of a BFILE or CLOB into the current CLOB. OCCI does not perform any … characterset conversions when loading data from a Bfile into a Clob. therefore, ensure that the contents of … the Bfile are character data in the server's Clob storage characterset. Syntax Description void copy … ); Copies

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

Clob Class

getCharSetForm()Returns the character set form of the CLOB. Syntax CharSetForm getCharSetForm() const;

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

Clob Class

getCharSetId()Returns the character set ID of the CLOB, in string form. Syntax string getCharSetId() const;

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

Clob Class

getCharSetIdUString()Retrieves the characterset name associated with the Clob. UString version. Syntax UString getCharSetIdUString() const;

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

Clob Class

isOpen()Tests whether the CLOB is open. If the CLOB is open, TRUE is returned; otherwise, FALSE is returned. Syntax bool isOpen() const;

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

Clob Class

setEmpty()Sets the Clob object to empty. Syntax Description void setEmpty(); Sets the Clob object to empty … . void setEmpty( const Connection* connectionp); Sets the Clob object to empty and initializes the … connection pointer to the passed parameter. Parameter Description connectionp The new connection pointer for the Clob

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

Clob Class

isNull()Tests whether the Clob object is atomically NULL. If the Clob object is atomically NULL, TRUE is

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

Clob Class

open()Opens the CLOB in read/write or read-only mode. Syntax void open( LObOpenMode mode … = OCCI_LOB_READWRITE); Parameter Description mode The mode the CLOB is to be opened in. Valid values are: OCCI_LOB_READWRITE OCCI_LOB_READONLY

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

Clob Class

operator!=()Compares two Clob objects for inequality. Two Clob objects are equal if they both refer to the same … CLOB. Two NULL Clob objects are not considered equal. If the Clob objects are not equal, then TRUE … is returned; otherwise, FALSE is returned. Syntax bool operator!=( const Clob &srcClob)

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

Clob Class

write()Writes data from a buffer into a CLOB. This method implicitly opens the CLOB, copies the buffer … into the CLOB, and implicitly closes the CLOB. If the CLOB is already open, use writeChunk() instead … , unsigned int offset=1); Writes data from a buffer into a CLOB. unsigned int write(

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

Datatype Comparison Rules

CHAR VARCHAR2 NCHAR NVARCHAR2 DATE DATETIME/INTERVAL NUMBER BINARY_FLOAT BINARY_DOUBLE LONG RAW ROWID…-- ROWID -- X X X -- -- -- -- -- -- -- -- -- -- -- CLOB X X X X -- -- -- -- -- X -- -- -- -- X BLOB … a CLOB value into a character datatype such as VARCHAR2, or converting BLOB to RAW data, if the data … types. Most SQL character functions are enabled to accept CLOB s as parameters, and Oracle performs … implicit conversions

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

Datatype Comparison Rules

to CHAR,VARCHAR2,NCHAR,NVARCHAR2 to NUMBER to Datetime/Interval to RAW to ROWID to LONG,LONG RAW to…-- -- from CLOB, NCLOB, BLOB TO_CHAR TO_NCHAR -- -- -- -- -- TO_CLOB TO_NCLOB -- -- from CLOB, NCLOB

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

Server Methods

CreateTempBLOB/CLOB Methodobject. Examples Example: Passing a Temporary CLOB to a Stored Procedure The following example … data and passed to a stored procedure which has an argument of type CLOB. Dim OraSession as OraSession … GetClobSize\" & _ \"(in_clob IN CLOB, clobsize OUT NUMBER) as Begin clobsize … \" & _ \":= DBMS_LOB.GETLENGTH(in_clob); End;\")

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

Globalization and Unicode Support

CLOB and NCLOB Data TypesOracle provides the CLOB and NCLOB data types for storing and processing large amounts of character … data. CLOB s represent data in the database characterset and NCLOB s represent data in the database … national characterset. CLOB s and NCLOB s can be used as column types in relational tables and as … attributes in object types.

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

Datatypes

EXTERNAL DATATYPES INTERNAL CLOB INTERNAL BLOBVARCHAR I/O   CHAR I/O   LONG I/O   LONG VARCHAR I/O   RAW   I/O VARRAW   I/O LONG RAW   I/O LONG VARRAW   I/O

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

Concatenation Operator

Concatenation OperatorThe concatenation operator manipulates character strings and CLOB data. Table 4-3 describes the concatenation operator.

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

Glossary

Character Large Object (CLOB)set. A CLOB may be indexed and searched by the Oracle Text search engine.

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

Glossary

Character Large Object (CLOB)set. A CLOB may be indexed and searched by the Oracle Text search engine.

Database SecureFiles and Large Objects Developer's Guide, 11g Release 1 (11.1)

Glossary

CLOBPronounced \"see-lob.\" See Character Large Object.

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

TO_CLOB

TO_CLOBcolumn or other character strings to CLOB values. char can be any of the datatypes CHAR, VARCHAR2 … , NCHAR, NVARCHAR2, CLOB, or NCLOB. Oracle Database executes this function by converting the underlying … statement converts NCLOB data from the sample pm.print_media table to CLOB and inserts it into a CLOB

Database SecureFiles and Large Objects Developer's Guide, 11g Release 1 (11.1)

PL/SQL Semantics for LOBs

PL/SQL CLOB Comparison RulesLike VARCHAR2 s, when a CLOB is compared with another CLOB or compared with a VARCHAR2, a set of

Database PL/SQL Packages and Types Reference, 11g Release 1 (11.1)

DBMS_SQL

CLOB_TABLE Table TypeThis is a table of CLOB. Syntax TYPE clob_table IS TABLE OF CLOB INDEX BY BINARY_INTEGER;

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

PL/SQL Language Fundamentals

Concatenation Operator, VARCHAR2, CLOB, or the equivalent Unicode-enabled type. If either string is a CLOB, the result is a … temporary CLOB. otherwise, it is a VARCHAR2 value. Example 2-32 and many other examples in this book

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

CHARTOROWID

CHARTOROWIDCHAR, VARCHAR2, NCHAR, or NVARCHAR2 datatype to ROWID datatype. This function does not support CLOB … data directly. However, CLOB s can be passed in as arguments through implicit data conversion. See

SQL*Plus User's Guide and Reference, 11g Release 1 (11.1)

SQL*Plus Error Messages

SP2-0548 Usage: VARIABLE NUMBER | CHAR | CHAR n CHAR|BYTE |VARCHAR2 n CHAR|BYTE | NCHAR |…]) |VARCHAR2 (n [CHAR|BYTE]) | NCHAR | NCHAR (n) |NVARCHAR2 (n) | CLOB | NCLOB | REFCURSOR |BINARY_FLOAT | BINARY_DOUBLE]]

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

TO_NCLOB

TO_NCLOBSyntax Description of the illustration to_nclob.gif Purpose TO_NCLOB converts CLOB values in a LOB … , NCHAR, NVARCHAR2, CLOB, or NCLOB. Oracle Database implements this function by converting the

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

VSIZE

VSIZEnot support CLOB data directly. However, CLOB s can be passed in as arguments through implicit data

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

HEXTORAW

HEXTORAWdoes not support CLOB data directly. However, CLOB s can be passed in as arguments through implicit

Database Readme, 11g Release 1 (11.1)

Oracle® Database Readme

3.3 Offset for CLOB and NCLOB APIsStarting with Oracle Database 10 g Release 1 (10.1), APIs that write to a CLOB or NCLOB cause error

Database SQLJ Developer's Guide and Reference, 11g Release 1 (11.1)

Type Support

Support for BLOB, CLOB, and BFILEmanipulate LOBs by using methods defined in the BLOB and CLOB classes, which is recommended, or by using … DBMS_LOB package. Using methods of the BLOB, CLOB, and BFILE classes in a Java application is more … . Methods in the BLOB, CLOB, and BFILE classes may also result in a round trip to the server. BFILE … with a call to DBMS_LOB.FILEOPEN

Database SecureFiles and Large Objects Developer's Guide, 11g Release 1 (11.1)

PL/SQL Semantics for LOBs

Implicit Conversions Between CLOB and VARCHAR2Implicit conversions from CLOB to VARCHAR2 and from VARCHAR2 to CLOB datatypes are allowed in PL … /SQL. These conversions enable you to perform the following operations in your application: CLOB … columns can be selected into VARCHAR2 PL/SQL variables VARCHAR2 columns can be selected into CLOB … variables Assignment

Database Globalization Support Guide, 11g Release 1 (11.1)

Choosing a Character Set

Abstract Datatype CHAR NCHAR BLOB CLOB NCLOBObject Yes Yes Yes Yes Yes Collection Yes Yes Yes Yes Yes You can create an abstract datatype with the NCHAR attribute as follows: SQL> CREATE TYPE tp1 AS OBJECT (a NCHAR(10)); Type created. SQL> CREATE TABLE t1 (a tp1); Table created. See Also: Oracle Database Application Developer's Guide - Object-Relational Features for more information about objects and collections

Database PL/SQL Packages and Types Reference, 11g Release 1 (11.1)

XMLTYPE

GETCLOBVALMember function. Returns a CLOB containing the serialized XML representation; if the returns is a … temporary CLOB, then it must be freed after use. Syntax MEMBER FUNCTION getClobVal() RETURN clob deterministic;

Database PL/SQL Packages and Types Reference, 11g Release 1 (11.1)

Database URI TYPEs

GETCLOBThis function returns the CLOB located by the HTTP URL address. If a temporary CLOB is returned, it … must be freed. Syntax Description MEMBER FUNCTION getClob() RETURN clob; Returns the CLOB located … clob; Returns the CLOB located at the address specified by the HTTP URL and the content

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

TO_MULTI_BYTE

TO_MULTI_BYTEsingle-byte and multibyte characters. This function does not support CLOB data directly. However … , CLOB s can be passed in as arguments through implicit data conversion. See Also: \"Datatype Comparison

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

TO_SINGLE_BYTE

TO_SINGLE_BYTE-byte and multibyte characters. This function does not support CLOB data directly. However, CLOB s can