Re: Help with insert

Hi

    Get the ascii value for character ' then pipe it (i guess ascii value for ' is 39)

 so if you need to insert, try insert as follows..

insert into test values ('inserting apostrophe '||chr(39)||' cheer....');

hope it help

Diego Pafumi wrote:

> I'm trying to create a varchar containing the ' character to be inserted in a
> table, but I receive an error.
> What I'm doing is:
>
> declare
> var varchar2(20);
> begin
> var := 'a';
> var := var || ''b'';
> insert into table values (var);
> end;
> /
>
> The question is: how can I do to pipe a value with ' ????
>
> Thanks !!!
Received on Thu Nov 19 1998 - 00:00:00 CST