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 CHR

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

SQL Reference, 9i Release 2 (

Functions, 18 of 177

CHRSyntax chr::= Text description of chr Purpose CHR returns the character having the binary … validated, and the result of specifying invalid codepoints is indeterminate. Note: Use of the CHR function … run on an ASCII-based machine with the database character set defined as WE8ISO8859P1: SELECT CHR

SQL Reference, 9i Release 2 (

Functions, 2 of 177


SQL Reference, 9i Release 2 (

Functions, 74 of 177

NCHRequivalent to number in the national character set. This function is equivalent to using the CHR function … with the USING NCHAR_CS clause. See Also: CHR Examples The following examples return the nchar … character 187: SELECT NCHR(187) FROM DUAL; NC -- > SELECT CHR(187 USING NCHAR_CS) FROM DUAL; CH -- >

XML Developer's Kits Guide - XDK, 9i Release 2 (


XSU Generating XML Example 2: Printing CLOB to Output Bufferwhen xmlstr is ; line:= substr(xmlstr,1,instr(xmlstr,chr(10))-1); dbms_output.put_line('| '||line … ); xmlstr:= substr(xmlstr,instr(xmlstr,chr(10))+1); end loop; end; /

Objects for OLE, 9i Release 2 (

CopyToClipboard Method Example

CopyToClipboard Method Example&) 'Now call CopyToClipboard to copy the entire dynaset OraDynaset.CopyToClipboard -1, chr(9), chr(13

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

Developing Web Applications with PL/SQL

Sending E-Mail from PL/SQLmessage.' || chr(13)); utl_smtp.write_data(mail_conn, 'This is line 2.' || chr(13)); utl_smtp.close_data

Performance Tuning Guide and Reference, 9i Release 2 (

Dynamic Performance Views for Tuning

V$PROCESSSELECT ' sid, serial#, aud sid: '|| s.sid||', '||s.serial#||', '|| s.audsid||chr(10)|| ' DB User … / OS User: '||s.username|| ' / '||s.osuser||chr(10)|| ' Machine - Terminal: '|| s.machine … ||' - '|| s.terminal||chr(10)|| ' OS Process Ids: '|| s.process||' (Client) '|| p.spid||' - '||||' (Server … )'|| chr(10)||

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (

DBMS_PIPE, 2 of 2

Example 1: Debugging; typ INTEGER; sta INTEGER; chr VARCHAR2(2000); BEGIN chr:= ''; sta:= dbms_pipe.receive_message … ('plsql_debug'); IF sta = 0 THEN DBMS_PIPE.UNPACK_MESSAGE(len); DBMS_PIPE.UNPACK_MESSAGE(chr); END IF … ;:status:= sta;:retval:= chr; IF len IS NOT NULL THEN:msg_length:= len; ELSE:msg_length:= 2000

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (

UTL_SMTP, 2 of 3

Usage Notescode fragment: utl_smtp.write_data(`some message.' || chr(13) || chr(10)); utl_smtp.write_data … (`.' || chr(13) || chr(10)); Since the sequence. is split between two calls to write_data(), the

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

Migrating From LONGs to LOBs

Calling PL/SQL and C Procedures from SQL or PL/SQLprocedure from PL/SQL. It is possible to pass a CLOB as an actual parameter where CHR is the formal

Reference, 9i Release 2 (

Oracle Wait Events, 4 of 5

Parameter Descriptionsto retrieve the name of the lock and the mode of the lock request: select chr(bitand(p1,-16777216 … )/16777215)|| chr(bitand(p1, 16711680)/65535) "Lock", bitand(p1, 65536) "Mode" from v$session_wait where … characters. Use the following SQL statement to retrieve the lock name. select chr(bitand(p1 … ,-16777216)/16777215)|| chr(bitand(p1,16711680)/65535)

SQL Reference, 9i Release 2 (

Functions, 146 of 177

TO_SINGLE_BYTE'A' in UTF8 to a single byte ASCII 'A': SELECT TO_SINGLE_BYTE( CHR(15711393)) FROM DUAL; T - A

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

Migrating From LONGs to LOBs

Converting LONG to LOB Example 13: Calling PL/SQL and C Procedures from PL/SQLactual parameter is a CHR: create procedure... declare c VARCHAR2[200]; begin get_lob('table_name

SQL*Plus® User's Guide and Reference, 9i Release 2 (

SQL*Plus Command Reference


Reference Guide, 9i Release 2 (

Data Types, Reserved Words, and Functions

Microsoft Access FunctionsAsc Ascii REPLACE IN PLACE Atn - * CCur CCUR CODE CDbl CDBL CODE Chr Chr NO ACTION Chr$ Chr NO

Streams, 9i Release 2 (

Monitoring a Streams Environment

Displaying Detailed Information About Apply ErrorsSYS.AnyData) IS tn VARCHAR2(61); str VARCHAR2(255); chr CHAR(255); num NUMBER; dat DATE; rw RAW(4000); res … tn = 'SYS.CHAR' then res:= data.GETCHAR(chr); DBMS_OUTPUT.PUT_LINE(chr); ELSIF tn = 'SYS.VARCHAR … ' THEN res:= data.GETVARCHAR(chr); DBMS_OUTPUT.PUT_LINE(chr); ELSIF tn = 'SYS.NUMBER' THEN res

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

Fundamentals of PL/SQL


Reference Guide for Microsoft SQL Server and Sybase Adaptive Server Migrations, 9i Release 2 (

Migrating Temporary Tables to Oracle

Package Body t_tabledbms_output.put_line (chr (9) || s); else sql_stmt:= sql_stmt || chr (10) || s; end if; end add; procedure … (sql_stmt); dbms_output.put_line( substr( sql_stmt, 2, instr( sql_stmt,chr(10),2)-2 ) ); sql_stmt:= NULL

Globalization Support Guide, 9i Release 2 (

Choosing a Character Set

What Characters Does a Character Set Support?values into the string (for example, by using the CHR or CONVERT SQL functions), then the values … Reference for more information about the CHR and CONVERT SQL functions "Displaying a Code Chart with the

Performance Tuning Guide and Reference, 9i Release 2 (

Instance Tuning

enqueuedisplayed in V$LOCK.TYPE: V$LOCK.TYPE = chr(bitand(P1,-16777216)/16777215)|| chr(bitand(P1,16711680)/65535