Single quote in Oracle

[MsJane]

Hi Gurus,

In SQL Server we double the single quote character in a string before sending to SQL Server, is this required also in Oracle?
For example in Text Area input of ASP page, I am concern of whether I will strip off the single quote character or double it before sending it Oracle database. Please help

Thank you very in advance.
MsJane

[Andrew_Fryer]

I think you will need to double it up, i.e

'''some text'''

Oracle tends to be funny about single quotes otherwise.

[MsJane]

Hi Andrew_Fryer,

Thank you very much.

MsJane