Re: SQLPlus: how to insert paragraphs of text with apostrophes and full stops

Where you have an apostrophe, escape it by typing it in twice:

'hello ol' world!'

becomes

'hello ol'' world!'

"Chrissy" <chrissysjunk_at_yahoo.co.uk> wrote in message news:de060d08.0304021213.10f2909b_at_posting.google.com...
> hi, i am currently inserting data into my database, but everytime i
> want to insert a paragraph of text into the database it wont let me,
> as i have apostrophes within the paragraph of text, which of course is
> not allowed.
>
> this is what i enter:
>
> Insert into product values
> (1, 'Brabantia Slimline Bin', 'Waste bins don't come any better than
> this. This bin has a large capacity yet takes up little space. It
> has a 'soft touch' lid that opens and closes with the slightest touch
> and keeps the odours in. Finally it's of superb quality in smart,
> brushed stainless steel with a removable inner liner for easy emptying
> and cleaning. 30 litre capacity.' 'bslimbin.jpg', 61.50,
> '30-apr-03'));
>
> could anyone tell me a way round this problem?
>
> thanks in advance!!
>
> chrissy
Received on Wed Apr 02 2003 - 23:02:22 CEST