How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
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
CLOB_TABLE Table Type → This is a table of CLOB. Syntax TYPE clob_table IS TABLE OF CLOB INDEX BY BINARY_INTEGER;
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
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
GETCLOBVAL → Member 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;
GETCLOB → This 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
GETCONTENTSCLOBBYRESID Function → This function obtains contents as a CLOB. Syntax DBMS_XDB_VERSION.GETCONTENTSCLOBYRESID( resid … DBMS_XDB.resid_type) RETURN CLOB; Parameters Table 151-5 GETCONTENTSCLOBYRESID Function Parameters Parameter Description resid The resource id.
GETCLOB → This function returns the CLOB located at the address specified by the URL. This function can be … overridden in the subtype instances. This function returns either a permanent CLOB or a temporary CLOB … . If a temporary CLOB is returned, it must be freed. The options are described in the following … table. Syntax