Results for CHR


1 to 20 of 25 results. Prev  Next


SQL Reference, 10g Release 1 (10.1)

CHR

CHRSyntax chr::= Description of the illustration chr.gif Purpose CHR returns the character having the … can be implicitly converted to NUMBER, and returns a character. Note: Use of the CHR function (either … ASCII-based machine with the database character set defined as WE8ISO8859P1: SELECT CHR(67)||CHR(65

Packages and Types Reference, 10g Release 1 (10.1)

157 UTL_I18N

ExamplesUTL_I18N.UNESCAPE_REFERENCE('abª') This returns 'ab'||chr(170).

Packages and Types Reference, 10g Release 1 (10.1)

157 UTL_I18N

ExamplesUTL_I18N.ESCAPE_REFERENCE('ab'||chr(170),'us7ascii') This returns 'abª'.

Packages and Types Reference, 10g Release 1 (10.1)

157 UTL_I18N

ExamplesDECLARE r raw(50); s varchar2(20); BEGIN s:='abcdef'||chr(170); r:=utl_i18n.string_to_raw(s,'utf8

SQL Reference, 10g Release 1 (10.1)

NCHR

NCHRthe CHR function with the USING NCHAR_CS clause. This function takes as an argument a NUMBER value … , or any value that can be implicitly converted to NUMBER, and returns a character. 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

Packages and Types Reference, 10g Release 1 (10.1)

157 UTL_I18N

Examplesfollowing string in the database character set: 'abcde'||chr(170) Piecewise Conversion … database character set: 'abcde'||chr(170) It also sets shf to SHIFT_IN and slen to 8. The following

Packages and Types Reference, 10g Release 1 (10.1)

157 UTL_I18N

Examplesfollowing string in the national character set: 'abcde'||chr(170) Piecewise Conversion … the national character set: 'abcde'||chr(170) It also sets shf to SHIFT_IN and slen to 8. The

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

13 Developing Web Applications with PL/SQL

Sending E-Mail from PL/SQL(). utl_smtp.open_data(mail_conn); utl_smtp.write_data(mail_conn, 'This is a test message.' || chr(13 … )); utl_smtp.write_data(mail_conn, 'This is line 2.' || chr(13)); utl_smtp.close_data(mail_conn

Oracle® XML Developer's Kit Programmer's Guide, 10g Release 1 (10.1)

24 XSU for PL/SQL

XSU Generating XML Example 2: Printing CLOB to Output Buffer:= dbms_lob.SUBSTR(result,32767); loop exit when 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;

Packages and Types Reference, 10g Release 1 (10.1)

63 DBMS_PIPE

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

Packages and Types Reference, 10g Release 1 (10.1)

164 UTL_SMTP

Usage Notes: UTL_SMTP.WRITE_DATA('some message.' || chr(13) || chr(10)); UTL_SMTP.WRITE_DATA('.' || chr(13) || chr(10

Packages and Types Reference, 10g Release 1 (10.1)

164 UTL_SMTP

Usage Notes: UTL_SMTP.WRITE_DATA('some message.' || chr(13) || chr(10)); UTL_SMTP.WRITE_DATA('.' || chr(13) || chr(10

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

13 Data Interface for Persistent LOBs

Calling PL/SQL and C Procedures from PL/SQLCHR is the formal parameter, or vice versa. The same holds for BLOBs and RAWs. One example of when … ... END; / The calling function could be of any of the following types: When the actual parameter is a CHR

Packages and Types Reference, 10g Release 1 (10.1)

104 DBMS_UTILITY

Examples; g_end_pos integer; FUNCTION Output_One_Line RETURN BOOLEAN IS BEGIN g_end_pos:= Instr ( i_buff, Chr(10 … (); EXCEPTION WHEN OTHERS THEN Log_Errors ( 'Error_Stack...' || Chr(10) || DBMS_UTILITY.FORMAT_ERROR_STACK … () ); Log_Errors ( 'Error_Backtrace...' || Chr(10) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE

SQL Reference, 10g Release 1 (10.1)

TO_SINGLE_BYTE

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

Reference, 10g Release 1 (10.1)

Parameter Descriptions

Parameter Descriptionsof the lock and the mode of the lock request: select chr(bitand(p1,-16777216)/16777215)|| chr(bitand … following SQL statement to retrieve the lock name. select chr(bitand(p1,-16777216)/16777215)|| chr

Globalization Support Guide, 10g Release 1 (10.1)

2 Choosing a Character Set

What Characters Does a Character Set Support?using the CHR or CONVERT SQL functions), then the values may be corrupted when they are sent to the … CHR and CONVERT SQL functions "Displaying a Code Chart with the Oracle Locale Builder" ASCII Encoding

Concepts and Administration, 10g Release 1 (10.1)

14 Monitoring a Streams Environment

Displaying Detailed Information About Apply ErrorsPROCEDURE print_any(data IN SYS.AnyData) IS tn VARCHAR2(61); str VARCHAR2(4000); chr VARCHAR2(1000); num … (str); DBMS_OUTPUT.PUT_LINE(SUBSTR(str,0,253)); ELSIF tn = 'SYS.CHAR' then res:= data.GETCHAR(chr … ); DBMS_OUTPUT.PUT_LINE(SUBSTR(chr,0,253)); ELSIF tn = 'SYS.VARCHAR' THEN res:= data.GETVARCHAR(chr … );

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

2 Fundamentals of the PL/SQL Language

Summary of PL/SQL Built-In FunctionsROUND SIGN SIN SINH SQRT TAN TANH TRUNC ASCII ASCIISTR CHR COMPOSE CONCAT DECOMPOSE INITCAP INSTR

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

5 Using SQL Workshop to Manage Database Objects

Using the SQL Script Repositoryfile with rows delimited by CHR (10) (that is, line feeds). If you export a DOS format then each row … is terminated with CHR(13)||CHR(10) (that is, CR LF or carriage return line feed). See Also: "Exporting an Application and Related Files"





Was this page helpful?

Integrated Cloud Applications & Platform Services