Results for TO_CLOB


1 to 20 of 26 results. Prev  Next


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

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

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)

Oracle9i Application Developer's Guide - Large Objects (LOBs) -- Index

T, 11-38 TO_BLOB(),TO_CHAR(), TO_NCHAR(), 7-47 TO_CLOB() TO_CLOB() converting VARCHAR2,NVARCHAR2

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

Modeling and Design

Using SQL Functions and Operators for VARCHAR2s on CLOBswith a LONG column. N/A N/A Conversion TO_CLOB TO_CLOB(varchar2Col) Yes Yes Conversion 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

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

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

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

Oracle9i Application Developer's Guide - Fundamentals -- Index

T), 20-2 TO_CHAR function, 3-38 CC date format, 3-21 RR date format, 3-12 TO_CLOB function, 3-38 TO_DATE

Concepts, 9i Release 2 (9.2.0.2)

Oracle9i Database Concepts -- Index

Tsupport default in views, 10-19 Julian dates, 12-11 TO_CLOB function TO_CLOB function data conversion

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)

Oracle9i SQL Reference -- Index

T) function, 6-170 TO_CHAR function, 2-63, 2-68, 2-76 TO_CLOB function, 6-175 TO_DATE function, 2-68, 2-73, 2


Was this page helpful?