Re: simple SQL question I think

From: Winnie Liu <poohland_at_hotmail.com>
Date: Tue, 7 Jul 1998 20:15:17 -0700
Message-ID: <6nuo0a$bho@sjx-ixn6.ix.netcom.com>

Oracle use '/' as the escape character, I think if you try to insert the line as 'Seeds /& Oil...', this should bypass the '&' character and SQLplus should treat that as a real character.
SQL*Plus will ask for the value whenever they see the '&' character.

Winnie Liu
DBA
Unihealth,CA

matsaki_at_statcan.ca wrote in message <6nr4ea$drh$1_at_nnrp1.dejanews.com>...
>Here's an easy one I hope:
>
>I'm trying to insert a string of text into a character field . The string
>includes an & symbol... eg: "Seeds & Oil Producing Seeds"
>
>I keep getting:
>
> old: "Seeds & Oil Producing Seeds"
> new: "Seeds Producting Seeds"
>
>Can someone help me out here? How do I force Oracle to take the & symbol?
>I've tried double single quotes around it, double quotes, but to no
avail...
>
>Thanx in advance.
>
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Tue Jul 07 1998 - 22:15:17 CDT