Problem with insert statement

[BHUSHAN]

Hi,

I would like to insert a string having ' charactor.
I am getting problem because of this
can any body help me ....
its verry urgent....

Thanks

Regards
Bhushan

[gandolf989]

When you are using ' on purpose, I think that you are asking for problems. Why don't you use " or ` instead?

[DaPi]

The single quote must be entered twice inside a quoted string:
Insert . . . Values('O''Neal', . . . . .)

[oracle_faq]

I would recommend using a bind variable in the insert statement. and that bnd variable can contain any value.

[BHUSHAN]

thanks everybody........