Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Insert character codes in Oracle with SQL command

Re: Insert character codes in Oracle with SQL command

From: Richard Kuhler <noone_at_nowhere.com>
Date: Thu, 13 Dec 2001 19:10:16 GMT
Message-ID: <s27S7.3088$AI.4778420@typhoon.san.rr.com> 





Use the chr() function.  chr(97) || chr(98) || chr(99) ('abc').  You'll
have to do the hexadecimal conversion yourself. :)




Richard




Sanjin wrote:


> 

> Hi,

> 

> Is it possible to insert character/s based on their character codes into

> Oracle database (8.0.5) with some SQL command?

> 

> i.e. INSERT INTO target_table VALUES 0x61 0x62 0x63 (values of characters

> codes, not characters i.e. 'abc').

> 

> Thanks in advance

> 

> Sanjin

Received on Thu Dec 13 2001 - 13:10:16 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US