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_NCHAR


1 to 20 of 26 results. Previous page Prev  Next next page


DML Reference, 10g Release 1 (10.1)

TO_NCHAR

TO_NCHARThe TO_NCHAR function converts a TEXT expression, date, or number to NTEXT in a specified format … . This function is typically used to format output data. Return Value NTEXT Syntax TO_NCHAR( text-exp … ) or TO_NCHAR( datetime-exp, [ datetime-fmt,] [ option setting ] or TO_NCHAR( num-exp, [ num-fmt,] [ nlsparams ] Arguments

DML Reference, 10g Release 1 (10.1)

TO_NCHAR

text-expNTEXT Always UTF8 Unicode The return value of the TO_NCHAR function has the NTEXT data type, which is … database, which can be UTF16. Similarity to SQL TO_NCHAR Function The OLAP DML TO_NCHAR function has … functionality similar to that of the SQL TO_NCHAR function. For more information about the SQL TO_NCHAR

SQL Reference, 10g Release 1 (10.1)

TO_NCHAR (datetime)

TO_NCHAR (datetime)Syntax to_nchar_date::= Description of the illustration to_nchar_date.gif Purpose TO_NCHAR … all orders whose status is 9 to the national character set: SELECT TO_NCHAR(order_date) FROM orders … WHERE order_status > 9; TO_NCHAR(ORDER_DATE) ---------------------------- 14-SEP-99 08.53.40.223345

SQL Reference, 10g Release 1 (10.1)

TO_NCHAR (character)

TO_NCHAR (character)Syntax to_nchar_char::= Description of the illustration to_nchar_char.gif Purpose TO_NCHAR … : SELECT TO_NCHAR(ad_fltextn) FROM print_media WHERE product_id = 3106; TO_NCHAR(AD_FLTEXTN

SQL Reference, 10g Release 1 (10.1)

TO_NCHAR (number)

TO_NCHAR (number)Syntax to_nchar_number::= Description of the illustration to_nchar_number.gif Purpose TO_NCHAR … character set: SELECT TO_NCHAR(customer_id) "NCHAR_Customer_ID" FROM orders WHERE order_status > 9; NCHAR_Customer_ID ----------------- 102 103 148 149 148

SQL Reference, 10g Release 1 (10.1)

Datatype Comparison Rules

to CHAR,VARCHAR2,NCHAR,NVARCHAR2 to NUMBER to Datetime/Interval to RAW to ROWID to LONG,LONG RAW to…, VARCHAR2, NCHAR, NVARCHAR2 TO_CHAR (char.) TO_NCHAR (char.) TO_NUMBER TO_DATE TO_TIMESTAMP … TO_BINARY_DOUBLE from NUMBER TO_CHAR (number) TO_NCHAR (number) — TO_DATE NUMTOYM- INTERVAL NUMTODS … - INTERVAL — — — — TO_BINARY_FLOAT TO_BINARY_DOUBLE from Datetime/ Interval TO_CHAR (date) TO_NCHAR (datetime … — — — — — — — — from

DML Reference, 10g Release 1 (10.1)

23 STDDEV to TRACKPRG

23 STDDEV to TRACKPRGTO_CHAR TO_DATE TO_NCHAR TO_NUMBER TOD TODAY TOTAL TRACEFILEUNIT TRACKPRG

Globalization Support Guide, 10g Release 1 (10.1)

7 Programming with Unicode

SQL Functions for Unicode Datatypes); Example 7-1 Populating the Customer Table Using the TO_NCHAR Function The TO_NCHAR function … customers VALUES (1000, TO_NCHAR('John Smith'),N'500 Oracle Parkway',sysdate); Example 7-2 Selecting

Application Developer's Guide - Large Objects, 10g Release 1 (10.1)

10 PL/SQL Semantics for LOBs

Explicit Conversion Functions(): Converting from RAW to a BLOB TO_CHAR() is enabled to convert a CLOB to a CHAR type. TO_NCHAR() is

Application Developer's Guide - Fundamentals, 10g Release 1 (10.1)

2 Selecting a Datatype

How Oracle Database Converts Datatypes: TO_NUMBER() TO_BINARY_FLOAT() TO_BINARY_DOUBLE() TO_CHAR() TO_NCHAR() TO_DATE() HEXTORAW() RAWTOHEX

DML Reference, 10g Release 1 (10.1)

A.2 Data Type Conversion

A.2 Data Type ConversionTO_NCHAR Converts a TEXT expression, date, or number to NTEXT in a specified format. TO_NUMBER

SQL Reference, 10g Release 1 (10.1)

TRANSLATE ... USING

TRANSLATE ... USINGfor ANSI compatibility. Oracle recommends that you use the TO_CHAR and TO_NCHAR functions, as … appropriate, for converting data to the database or national character set. TO_CHAR and TO_NCHAR can take

SQL Reference, 10g Release 1 (10.1)

SQL Functions

Single-Row FunctionsTO_DSINTERVAL TO_LOB TO_MULTI_BYTE TO_NCHAR (character) TO_NCHAR (datetime) TO_NCHAR (number) TO_NCLOB

SQL Quick Reference, 10g Release 1 (10.1)

2 SQL Functions

Syntax for SQL Functions[ 'nlsparam' ]) TO_LOB TO_LOB(long_column) TO_MULTI_BYTE TO_MULTI_BYTE(char) TO_NCHAR (character … ) TO_NCHAR({char | clob | nclob} [, fmt [, 'nlsparam' ] ] ) TO_NCHAR (datetime) TO_NCHAR({ datetime … | interval } [, fmt [, 'nlsparam' ] ] ) TO_NCHAR (number) TO_NCHAR(n [, fmt [, 'nlsparam'

Globalization Support Guide, 10g Release 1 (10.1)

11 Character Set Migration

Migrating CHAR Columns to NCHAR Columnsfollowing: DBMS_REDEFINITION.START_REDEF_TABLE('scott', 'emp', 'int_emp', 'empno empno, to_nchar(ename … ) ename, to_nchar(job) job, mgr mgr, hiredate hiredate, sal sal, deptno deptno, to_nchar(org) org'); If … instead of the TO_NCHAR SQL function. Create triggers, indexes, grants, and constraints on the interim

DML Reference, 10g Release 1 (10.1)

B.1 Statements Added

B.1 Statements Added(9.0.0.0) TO_DATE (9.0.0.0) TO_NCHAR (9.2.0.0) TO_NUMBER (9.0.0.0) TRACEFILEUNIT (9.2.0.0) TRIGGER command

Globalization Support Guide, 10g Release 1 (10.1)

9 SQL and PL/SQL Programming in a Global Environment

Specifying NLS Parameters in SQL FunctionsNLS_DATE_LANGUAGE NLS_NUMERIC_CHARACTERS NLS_CURRENCY NLS_ISO_CURRENCY NLS_DUAL_CURRENCY NLS_CALENDAR TO_NCHAR

DML Reference, 10g Release 1 (10.1)

3.4 Numeric Expressions

3.4.3 Automatic Conversion of Numeric Data Typesyou want, then you can use the CONVERT, TO_CHAR, TO_NCHAR, TO_NUMBER, or TO_DATE functions to get different results.

User's Guide and Reference, 10g Release 1 (10.1)

2 Fundamentals of the PL/SQL Language

Summary of PL/SQL Built-In FunctionsTO_MULTI_BYTE TO_NCHAR TO_NCLOB TO_NUMBER TO_SINGLE_BYTE ADD_MONTHS CURRENT_DATE CURRENT_TIME

DML Reference, 10g Release 1 (10.1)

PROPERTY

nameyou explicitly convert the value you specify to NTEXT (using the CONVERT or TO_NCHAR functions