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 TO_CLOB


1 to 17 of 17 results.


SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 2 of 177

TO_CLOBTO_DATE TO_DSINTERVAL

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 136 of 177

TO_CLOBSyntax to_clob::= Text description of to_clob Purpose TO_CLOB converts NCLOB values in a LOB column … existing data in that column. UPDATE PRINT_MEDIA SET AD_FINALTEXT = TO_CLOB (AD_FLTEXTN);

Application Developer's Guide - Large Objects, 9i Release 2 (9.2.0.2)

Modeling and Design

SQL and PL/SQL CHAR to CLOB Conversion Functions() converts CLOB or NCLOB to CHAR or NCHAR TO_CLOB() and TO_NCLOB() converts CHAR or NCHAR to CLOB or NCLOB

Application Developer's Guide - Large Objects, 9i Release 2 (9.2.0.2)

Migrating From LONGs to LOBs

Explicit Conversion Functionsdata types to CLOB and BLOB as part of LONG-to-LOB migration: TO_CLOB() converts LONG, VARCHAR2, and

Application Developer's Guide - Fundamentals, 9i Release 2 (9.2.0.2)

Selecting a Datatype

How Oracle Converts Datatypes() TO_CLOB() TO_NCLOB() TO_BLOB() TO_RAW() Implicit datatype conversions work according to the rules explained below.

Concepts, 9i Release 2 (9.2.0.2)

Native Datatypes

Data Conversionsome of the functions used: TO_NUMBER() TO_CHAR() TO_NCHAR() TO_DATE() TO_CLOB() TO_NCLOB

Application Developer's Guide - Large Objects, 9i Release 2 (9.2.0.2)

Modeling and Design

Explicit Conversion Functionsdata types to CLOB, NCLOB, and BLOB as part of the LONG-to-LOB migration: TO_CLOB(): Converting

Globalization Support Guide, 9i Release 2 (9.2.0.2)

Programming with Unicode

Implicit Datatype Conversion Between NCHAR and Other Datatypes, use Oracle's explicit conversion functions, TO_CLOB and TO_NCLOB. See Also: Oracle9i SQL Reference

Application Developer's Guide - Large Objects, 9i Release 2 (9.2.0.2)

Modeling and Design

Using SQL Functions and Operators for VARCHAR2s on CLOBsLONG column. N/A N/A Conversion TO_CLOB TO_CLOB(varchar2Col) Yes Yes Conversion TO_NCLOB TO_NCLOB

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Fundamentals of PL/SQL

Built-In FunctionsCHARTOROWID CONVERT HEXTORAW RAWTOHEX ROWIDTOCHAR TO_BLOB TO_CHAR TO_CLOB TO_DATE TO_MULTI_BYTE TO_NCLOB

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Datatypes

Implicit ConversionCLOB and NCLOB, you must use the conversion functions TO_CLOB and TO_NCLOB. TIMESTAMP, TIMESTAMP WITH

Error Messages, 9i Release 2 (9.2.0.2)

ORA-29250 to ORA-32799

ORA-32766 instr with negative offset: use varchar semantics on LOBs, whereas instr(to_clob('abcd'), 'cd', -2, 1) returns 0, (for example, no match), because the reverse … LOBs (instr). Using the same example, instr(to_clob('abcd'), 'cd', -2, 1) will return 3 as in the

SQL Reference, 9i Release 2 (9.2.0.2)

Basic Elements of Oracle SQL, 2 of 10

Data ConversionHEXTORAW CHARTOROWID -- TO_CLOB TO_NCLOB from NUMBER TO_CHAR (number) TO_NCHAR (number) -- TO_DATE … -- -- -- -- -- TO_CLOB TO_NCLOB Note: You cannot specify LONG and LONG RAW values in cases in which

SQL Reference, 9i Release 2 (9.2.0.2)

Oracle9i SQL Reference -- Contents

Oracle9i SQL Reference -- Contents(character) TO_CHAR (datetime) TO_CHAR (number) TO_CLOB TO_DATE TO_DSINTERVAL TO_LOB TO_MULTI_BYTE

New Features, 9i Release 2 (9.2.0.2)

Oracle9i Database Release 1 (9.0.1) New Features

SQL and PL/SQL ImprovementsSYS_XMLGEN SYSTIMESTAMP TO_CHAR (character) TO_CLOB TO_DSINTERVAL TO_TIMESTAMP TO_TIMESTAMP_TZ

Application Developer's Guide - Fundamentals, 9i Release 2 (9.2.0.2)

Using Triggers

Accessing Column Values in Row Triggers… -- operations for a CLOB, or DBMS_LOB calls for a BLOB.:NEW.c1:=:NEW.c1 || to_clob('Standard footer

SQL Reference, 9i Release 2 (9.2.0.2)

What's New in SQL Reference?

Oracle9 i Release 1 (9.0.1) New Features in the SQL ReferenceSYS_XMLAGG SYS_XMLGEN SYSTIMESTAMP TO_CHAR (character) TO_CLOB TO_DSINTERVAL TO_NCHAR (character) TO_NCHAR