RE: Inserting an ampersand (&)

You can always do a quick pl/sql to loop printing the chr(x) changing x for each iteration.

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

From:	Maser, Donna  (SEA) [SMTP:DonnaMaser_at_chiroscience.com]
Sent:	Monday, November 20, 2000 3:51 PM
To:	Multiple recipients of list ORACLE-L
Subject:	RE: Inserting an ampersand (&)

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

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

Sent: Monday, November 20, 2000 11:06 AM To: Multiple recipients of list ORACLE-L

use the chr() function to insert any special characters into a table.  Simply concatenate the character to your existing strings and your all set.

Some special characters:

	!	33
	"	34
	#	35
	$	36
	%	37
	&	38
	'	39
	(	40
	)	41
	*	42




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

From:	Paul van Dijken [SMTP:paul.vandijken_at_sema.nl]
Sent:	Monday, November 20, 2000 10:00 AM
To:	Multiple recipients of list ORACLE-L
Subject:	Inserting an ampersand (&)

I know I should know, but I can't remember and I can't find it in the FM.

How do I insert an & sign into a table like .....values('mothers & daughters') ??

Thanx
Paul

The information contained in this email is intended for the personal and confidential use of the addressee only. It may also be privileged information. If you are not the intended recipient then you are hereby notified that you have received this document in error and that any review, distribution or copying of this document is strictly prohibited. If you have received this communication in error, please notify Celltech Group immediately on:

+44 (0)1753 534655, or email 'is_at_celltech.co.uk'

Celltech Group plc
216 Bath Road, Slough, SL1 4EN, Berkshire, UK

Registered Office as above. Registered in England No. 2159282

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Maser, Donna  (SEA)
  INET: DonnaMaser_at_chiroscience.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