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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Inserting an ampersand (&)

Re: Inserting an ampersand (&)

From: bunyamin karadeniz <bunyamink_at_havelsan.com.tr>
Date: Fri, 22 Sep 2000 14:52:51 +0300
Message-Id: <10687.122605@fatcity.com>


Smile and Try

SET DEF OFF ; and then insert it;



Bunyamin K. Karadeniz
Enformasyon Teknolojileri Dir.
Veri Tabani Grubu tel : 2873565/1681
HAVELSAN

You can use SQL*Plus, if you are running it as a client from windows:

SQL> select ascii('') from dual;

ASCII('')


       181

SQL> select chr(181) from dual;

CHR
---

Or, again from windows, you can bring up the character map tool, choose a font like Courier, and find the character you are looking for. The hex ascii code is displayed for the character when you click on it. Convert to decimal, and there you are!

Diana

-----Original Message-----

Sent: Monday, November 20, 2000 3:51 PM
To: Multiple recipients of list ORACLE-L

I have used the chr() function for some things, now I need to insert - the greek letter mu.

Anyone know a quick and easy way to find the ASCII value so I can use the chr() function
to insert this character into the database?

TIA,
Donna Maser
Oracle DBA

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Diana Duncan
  INET: Diana_at_fileFRENZY.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists

--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Sep 22 2000 - 06:52:51 CDT

Original text of this message

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