Storing special characters(') into oracle

How to store special characters(') into oracle database?

Use PreparedStatement

Shailesh

Indetail explanation please...with example
Suppose if I want to insert "Sriman's" aganist name DB field...How is this achieved?

By binding the String parameter using a PreparedStatement. Change you code to use a PreparedStatement and you'll see how it works.

Originally posted by Praveena Modugula:
Indetail explanation please...with example
Suppose if I want to insert "Sriman's" aganist name DB field...How is this achieved?

http://www.google.com/search?q=preparedstatement+tutorial

Any of the first few results will tell you want you need to know.

try it by first replacing (') by \\' in the string

You can also add a "'" to your sql statment.
For e.g
insert into Restaurant (name) ('Nick''s Place');
will insert a restraurant name Nick's Place.

Eleanor Leong