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


41 to 80 of 1383 results. previous page Prev  Next next page
Results per page:  20 |  40  | 60


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 PL/SQL Packages and Types Reference, 11g Release 1 (11.1)

DBMS_XDB_VERSION

GETCONTENTSCLOBBYRESID FunctionThis 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.

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

Database URI TYPEs

GETCLOBThis 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

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

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

ASCII

ASCII… This function does not support CLOB data directly. However, CLOB s can be passed in as arguments

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

REPLACE

REPLACE, NCHAR, NVARCHAR2, CLOB, or NCLOB. The string returned is in the same character set as char. The … function returns VARCHAR2 if the first argument is not a LOB and returns CLOB if the first argument is a

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

TO_NUMBER

TO_NUMBERinterpreted only by its internal presentation. This function does not support CLOB data directly. However … , CLOB s can be passed in as arguments through implicit data conversion. See Also: \"Datatype

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

INITCAP

INITCAP-sensitive uppercase and lowercase, refer to NLS_INITCAP. This function does not support CLOB data … directly. However, CLOB s can be passed in as arguments through implicit data conversion. See Also

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

UPPER

UPPERuppercase. char can be any of the datatypes CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB. The return

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

TO_NCHAR (character)

TO_NCHAR (character)(character) converts a character string, CHAR, VARCHAR2, CLOB, or NCLOB value to the national character set

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

CONCAT

CONCATchar2. Both char1 and char2 can be any of the datatypes CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or … national datatype. For example: CONCAT ( CLOB, NCLOB ) returns NCLOB CONCAT ( NCLOB, NCHAR ) returns … NCLOB CONCAT ( NCLOB, CHAR ) returns NCLOB CONCAT ( NCHAR, CLOB ) returns NCLOB This function is

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

Datatypes

XMLType, you can choose to store the XML data in a CLOB column, as binary XML (stored internally as a CLOB … in underlying object-relational columns by default, but you can specify storage in a CLOB or binary

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

Concatenation Operator

Table 4-3 Concatenation OperatorOperator Purpose Example || Concatenates character strings and CLOB data. SELECT 'Name is … datatype VARCHAR2 and is limited to 4000 characters. If either argument is a CLOB, the result is a … temporary CLOB. Trailing blanks in character strings are preserved by concatenation, regardless of the … datatypes of the string or CLOB.

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

JMS Types

set_text (payload IN VARCHAR2)Sets the payload, a VARCHAR2 value, to an internal representation. set_text (payload IN CLOB) Sets … the payload, a CLOB value, to an internal representation. get_text (payload OUT VARCHAR2) Puts the … internal representation of the payload into a VARCHAR2 variable payload. get_text (payload OUT CLOB … ) Puts the internal representation

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

DBMS_XMLDOM

WRITETOCLOB Proceduressyntax declarations. Syntax Writes XML node to specified CLOB using the database character set (See Also … : DOMNode Subprograms ): DBMS_XMLDOM.WRITETOCLOB( n IN DOMNODE, cl IN OUT CLOB); Writes XML document … to a specified CLOB using database character set (See Also: DOMDocument Subprograms … ): DBMS_XMLDOM.WRITETOCLOB( doc

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

LOWER

LOWERlowercase. char can be any of the datatypes CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB. The return

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

NLS_LOWER

NLS_LOWER, CLOB, or NCLOB. The string returned is of VARCHAR2 datatype if char is a character datatype and a

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

PL/SQL Data Types

Predefined PL/SQL Large Object (LOB) Data Types128 terabytes (TB) CLOB Used to store large blocks of character data in the database. 8 to 128 TB … external file, LOB locators are in columns of the types BFILE, BLOB, CLOB, and NCLOB. PL/SQL operates … object type attribute BFILE, BLOB, CLOB: Yes NCLOB: No No See Also: LONG and LONG RAW Data Types … : BFILE Data Type BLOB Data

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

Working with LOBs and BFILEs

Creating and Populating a BLOB, CLOB or NCLOB ColumnCreate and populate a BLOB, CLOB, or NCLOB column in a table by using SQL statements. Note: You … cannot construct a new BLOB, CLOB, or NCLOB locator in your application with a Java new statement. You … factory methods from oracle.jdbc.OracleConnection interface. Create a BLOB, CLOB, or NCLOB column … BLOB, CLOB,

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

Working with LOBs and BFILEs

Getting and Passing BLOB, CLOB, and NCLOB Locators, CLOB, and NCLOB Locators Passing BLOB, CLOB and NCLOB Locators Retrieving BLOB, CLOB, and NCLOB … Locators Given a standard JDBC result set or callable statement that includes BLOB, CLOB, or NCLOB … , getClob, and getNClob methods, which return java.sql.Blob, Clob, and NClob objects, respectively

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

PL/SQL Semantics for LOBs

VARCHAR2 and CLOB in PL/SQL Built-In FunctionsCLOB and VARCHAR2 are still two distinct types. But depending on the usage, a CLOB can be passed to … , \"CLOB Variables in PL/SQL\". PL/SQL VARCHAR2 functions and operators can take CLOB s as arguments or … function that returns a CLOB, or a SELECT on a CLOB column, an error should

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

Working with LOBs and BFILEs

Accessing and Manipulating BLOB, CLOB, or NCLOB DataOnce you have your BLOB, CLOB, or NCLOB locator in a table, you can access and manipulate the data … , CLOB, or NCLOB data. After retrieving the BLOB, CLOB, or NCLOB data, you can manipulate it however you