Inserting text with single quotes?

Hi,

Is there any way to insert large blocks of text that contain single quotes (')?

I know that '' will place a ' into an Oracle field. Is there any way to change the ' to another character for one transaction, then change it back?

Something along the lines of:

set text_terminator ";
update table set ttext="what's up?" where id = 1; set text_terminator ';

Thanks,

Park Received on Sat Apr 06 1996 - 00:00:00 CEST