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

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 - 22:13:03 CEST