Insert of 'special' (& CR/LF ') char in SQL INSERT
From: Robert K Smith <rs6_at_inel.gov>
Date: 16 Mar 1994 15:43:27 GMT
Message-ID: <2m79ev$45h_at_mica.inel.gov>
Date: 16 Mar 1994 15:43:27 GMT
Message-ID: <2m79ev$45h_at_mica.inel.gov>
I have found that to insert a single ' into a field using INSERT the ' needs to be doubled to ''. How do you insert a &? Given that my company is EG&G, and my customers don't like seeing EG+G, I'd like to know how this is done. I'd expect this is a simple thing, maybe already in a FAQ, but I don't see a FAQ here either.
I am also often asked if it is possible to insert a CR/LF into an
Oracle CHAR field.
Thanks for your help!! Voice: (208) 526-5801 Fax: (208) 526-8480