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_CHAR


1 to 20 of 254 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 2 of 177

TO_CHAR (character)TO_CHAR (datetime) TO_CHAR (number)

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 134 of 177

TO_CHAR (datetime)Syntax to_char_date::= Text description of to_char_date Purpose TO_CHAR (datetime) converts date of … the results of applying TO_CHAR to different TIMESTAMP datatypes. The result for a TIMESTAMP WITH … :00', TIMESTAMP'1999-12-02 10:00:00 -8:00', TIMESTAMP'1999-12-02 10:00:00 -8:00'); SELECT TO_CHAR … (ts_col, 'DD-MON-YYYY HH24:MI:SSxFF'),

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 135 of 177

TO_CHAR (number)Syntax to_char_number::= Text description of to_char_number Purpose TO_CHAR (number) converts n of … implicit conversion to interpret a string and a number into a number: SELECT TO_CHAR('01110' + 1 … ) FROM dual; TO_C ---- 1111 Compare this example with the first example for TO_CHAR (character). In the … next example, the output

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 133 of 177

TO_CHAR (character)Syntax to_char_char::= Text description of to_char_char Purpose TO_CHAR (character) converts NCHAR … interprets a simple string as character data: SELECT TO_CHAR('01110') FROM DUAL; TO_CH ----- 01110 Compare … this example with the first example for TO_CHAR (number). The following example converts some CLOB … data from the pm.print_media

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

ORDVideo Reference Information

Examples); DBMS_OUTPUT.put_line('width: ' || TO_CHAR(width)); DBMS_OUTPUT.put_line('height: ' || TO_CHAR(height … )); DBMS_OUTPUT.put_line('format: ' || obj.getFormat()); DBMS_OUTPUT.put_line('frame resolution: ' ||TO_CHAR … (obj.getFrameResolution())); DBMS_OUTPUT.put_line('frame rate: ' || TO_CHAR(obj.getFrameRate

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

ORDAudio Reference Information

Examples: ' || obj.getEncoding); DBMS_OUTPUT.put_line('numberOfChannels: ' || TO_CHAR(obj.getNumberOfChannels … )); DBMS_OUTPUT.put_line('samplingRate: ' || TO_CHAR(obj.getSamplingRate)); DBMS_OUTPUT.put_line … ('sampleSize: ' || TO_CHAR(obj.getSampleSize)); DBMS_OUTPUT.put_line('compressionType … : ' || obj.getCompressionType); DBMS_OUTPUT.put_line('audioDuration:

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

ORDAudio Reference Information

Examples: ' || obj.getEncoding()); DBMS_OUTPUT.put_line('numberOfChannels: ' || TO_CHAR(obj.getNumberOfChannels … ())); DBMS_OUTPUT.put_line('samplingRate: ' || TO_CHAR(obj.getSamplingRate())); DBMS_OUTPUT.put_line … ('sampleSize: ' || TO_CHAR(obj.getSampleSize())); DBMS_OUTPUT.put_line('compressionType … : ' || obj.getCompressionType());

Globalization Support Guide, 9i Release 2 (9.2.0.2)

SQL and PL/SQL Programming in a Global Environment

Unacceptable NLS Parameters in SQL FunctionsTO_CHAR or TO_DATE function. As a result, NLS_DATE_FORMAT is not a valid NLS parameter for the TO_CHAR or … TO_DATE functions. If NLS_LANGUAGE or NLS_TERRITORY is specified in the TO_CHAR, TO_NUMBER, or … . For example, the following specification is legal: TO_CHAR (hire_date, 'DD/MON/YYYY … ', 'nls_date_language

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

Common Methods for interMedia Object Types Reference Information

Examplesobj.importFrom(ctx,'file','VIDEODIR','MV1.AVI'); -- check size DBMS_OUTPUT.PUT_LINE(TO_CHAR … (obj.getContentLength(ctx))); DBMS_OUTPUT.PUT_LINE(TO_CHAR(DBMS_LOB.GETLENGTH(obj.getContent … ('-----------------'); obj.deleteContent(); DBMS_OUTPUT.PUT_LINE(TO_CHAR(obj.getContentLength(ctx))); UPDATE TVID SET vid=obj WHERE N=1; COMMIT; END;

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

ORDAudio Reference Information

Examples: ' || obj.getEncoding()); DBMS_OUTPUT.put_line('numberOfChannels: ' || TO_CHAR(obj.getNumberOfChannels … ())); DBMS_OUTPUT.put_line('samplingRate: ' || TO_CHAR(obj.getSamplingRate())); DBMS_OUTPUT.put_line('sampleSize … : ' || TO_CHAR(obj.getSampleSize())); update TAUD set aud = obj where N =1. COMMIT; EXCEPTION WHEN

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

SQL for Analysis in Data Warehouses

LAG/LEAD Syntaxtable or partition. Example 19-10 LAG/LEAD SELECT time_id, TO_CHAR(SUM(amount_sold),'9,999,999') AS … SALES, TO_CHAR(LAG(SUM(amount_sold),1) OVER (ORDER BY time_id),'9,999,999') AS LAG1, TO_CHAR(LEAD(SUM

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

ORDAudio Reference Information

ExamplesDBMS_OUTPUT.PUT_LINE(TO_CHAR(obj.getContentLength(ctx))); DBMS_OUTPUT.PUT_LINE(obj.getSource … ('-----------------'); obj.deleteContent(); DBMS_OUTPUT.PUT_LINE(TO_CHAR(obj.getContentLength(ctx))); DBMS_OUTPUT.PUT_LINE(TO_CHAR

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

Common Methods for interMedia Object Types Reference Information

Examples; BEGIN SELECT aud INTO obj FROM TAUD WHERE N = 1. DBMS_OUTPUT.PUT_LINE(TO_CHAR(obj.getUpdateTime(),'MM-DD-YYYY HH24:MI:SS')); END; /

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

Creating Dimension Materialized Views, 4 of 5

Sample Script for the TIMES_DIM DimensionTIMES_CAL_R_OLAP ( (CASE GID WHEN(7) THEN NULL WHEN(3) THEN TO_CHAR( CALENDAR_YEAR) WHEN(1) THEN … TO_CHAR( CALENDAR_QUARTER_DESC) ELSE TO_CHAR( CALENDAR_MONTH_DESC) END) ) TABLESPACE SH_IDX PCTFREE 0 … ( (CASE GID WHEN(7) THEN TO_CHAR( CALENDAR_YEAR) WHEN(3) THEN TO_CHAR( CALENDAR_QUARTER_DESC) WHEN(1

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

Modeling and Design

SQL and PL/SQL CHAR to CLOB Conversion FunctionsThe following CHAR to CLOB conversion functions are now allowed for LOBs: TO_CHAR() and TO_NCHAR

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

interMedia Relational Interface Reference

Examples' || TO_CHAR(DBMS_LOB.GETLENGTH(img_attrib))); EXCEPTION WHEN OTHERS THEN RAISE; END; /

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

ORDAudio Reference Information

Examples(TO_CHAR(obj.getContentLength(ctx))); DBMS_OUTPUT.PUT_LINE(obj.getSource()); DBMS_OUTPUT.PUT_LINE('deleting … (TO_CHAR(obj.getContentLength(ctx))); UPDATE TAUD SET aud=obj WHERE N=1; COMMIT; END; /

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 130 of 177

SYSTIMESTAMPfractional seconds: SELECT TO_CHAR(SYSTIMESTAMP, 'SSSS.FF') FROM DUAL; TO_CHAR(SYSTIM -------------- 5050.105900

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

ORDVideo Reference Information

ExamplesDBMS_OUTPUT.PUT_LINE(obj.getSource()); -- import data obj.import(ctx); -- check size DBMS_OUTPUT.PUT_LINE(TO_CHAR … contents'); DBMS_OUTPUT.PUT_LINE('-----------------'); obj.deleteContent(); DBMS_OUTPUT.PUT_LINE(TO_CHAR

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

PL/SQL Packages

How Package STANDARD Defines the PL/SQL Environmentoverloaded. For example, package STANDARD contains the following declarations: FUNCTION TO_CHAR (right … DATE) RETURN VARCHAR2; FUNCTION TO_CHAR (left NUMBER) RETURN VARCHAR2; FUNCTION TO_CHAR (left DATE … , right VARCHAR2) RETURN VARCHAR2; FUNCTION TO_CHAR (left NUMBER, right VARCHAR2) RETURN VARCHAR2; PL … /SQL