add an '

[Saj]

how can I add an ' mark in an oracle query?what do I have to put infront of it.

[michaelb]

Did you try to use a backslash as an escape character?

You may want to look at this thread:

http://www.thescripts.com/forum/thread575255.html

[Reshmi Jacob]

Hi

You can use

INSERT INTO Table VALUES ('''', value2,...);

to insert a single quotes u replace it with 4 Single Quotes

Reshmi