Inserting '&string' in SQL*Plus

From: Keith Shum <kshum_at_iLux.com>
Date: Mon, 13 Nov 2000 14:13:53 -0800
Message-Id: <10680.122010@fatcity.com>

Hello, all,

I have an interesting one on Monday... (I know, I know, we shouldn't do anything of brain twisting today...)

While using SQL*Plus to INSERT a string with the special character '&' like '&something' to a table, without using SET ESCAPE command, how can we do it? Since the '&' is a reserved character for variable...

Thanks!

--

Keith Shum

kshum_at_iLux.com

iLux Corporation
Phone (510) 226-5600 x 643
Fax (510) 226-8182
Cellular Phone (510) 435-0286
5600 Mowry School Road, Newark, CA 94560
http://www.iLux.com

Received on Mon Nov 13 2000 - 16:13:53 CST