CLOB Datatype → The 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,
CLOB Data Type → You 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
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
CLOB and NCLOB Datatypes → The 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
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.
length() → Returns the number of characters in the CLOB. Syntax unsigned int length() const;
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
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.
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.
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
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
close() → Closes a CLOB. Syntax void close();
getChunkSize() → Returns the smallest data size to perform efficient writes to the CLOB. Syntax unsigned int getChunkSize() const;
Method Summary → Clob() 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
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.
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
isInitialized() → Tests whether the Clob object is initialized. If the Clob object is initialized, TRUE is returned
setCharSetId() → Sets the Character set Id associated with Clob. The characterset id set will be used for read/write
setCharSetIdUString() → Sets the Character set Id associated with Clob. used when the environment's characterset is UTF16
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.
Clob Class → The 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
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
setNull() → Sets the Clob object to atomically NULL. Syntax void setNull();
closeStream() → Closes the Stream object obtained from the CLOB. Syntax void closeStream( Stream *stream
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
getCharSetForm() → Returns the character set form of the CLOB. Syntax CharSetForm getCharSetForm() const;
getCharSetId() → Returns the character set ID of the CLOB, in string form. Syntax string getCharSetId() const;
getCharSetIdUString() → Retrieves the characterset name associated with the Clob. UString version. Syntax UString getCharSetIdUString() const;
isOpen() → Tests whether the CLOB is open. If the CLOB is open, TRUE is returned; otherwise, FALSE is returned. Syntax bool isOpen() const;
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
isNull() → Tests whether the Clob object is atomically NULL. If the Clob object is atomically NULL, TRUE is
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
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)
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(
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
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
CreateTempBLOB/CLOB Method → object. 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;\")
CLOB and NCLOB Data Types → Oracle 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.
EXTERNAL DATATYPES INTERNAL CLOB INTERNAL BLOB → VARCHAR 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
Concatenation Operator → The concatenation operator manipulates character strings and CLOB data. Table 4-3 describes the concatenation operator.
Character Large Object (CLOB) → set. A CLOB may be indexed and searched by the Oracle Text search engine.
Character Large Object (CLOB) → set. A CLOB may be indexed and searched by the Oracle Text search engine.
CLOB → Pronounced \"see-lob.\" See Character Large Object.
TO_CLOB → column 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
PL/SQL CLOB Comparison Rules → Like VARCHAR2 s, when a CLOB is compared with another CLOB or compared with a VARCHAR2, a set of
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
CLOB_TABLE Table Type → This is a table of CLOB. Syntax TYPE clob_table IS TABLE OF CLOB INDEX BY BINARY_INTEGER;
CHARTOROWID → CHAR, 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
SP2-0548 Usage: VARIABLE
TO_NCLOB → Syntax 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
VSIZE → not support CLOB data directly. However, CLOB s can be passed in as arguments through implicit data
HEXTORAW → does not support CLOB data directly. However, CLOB s can be passed in as arguments through implicit
3.3 Offset for CLOB and NCLOB APIs → Starting with Oracle Database 10 g Release 1 (10.1), APIs that write to a CLOB or NCLOB cause error
Support for BLOB, CLOB, and BFILE → manipulate 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
Implicit Conversions Between CLOB and VARCHAR2 → Implicit 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
Abstract Datatype CHAR NCHAR BLOB CLOB NCLOB → Object 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
TO_MULTI_BYTE → single-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
TO_SINGLE_BYTE → -byte and multibyte characters. This function does not support CLOB data directly. However, CLOB s can
ASCII → … This function does not support CLOB data directly. However, CLOB s can be passed in as arguments