special charcter in oracle urgent

[pavi kavi]

Hello
I have a problem in inserting the follwoign special charcter into oracle
1.&
2.'
3.%
4.@
can some body tell me how can i do it in java
pavithra

[Jamie Robertson]

the easiest way to deal with special characters in oracle is:

String sql = "insert into test values (1,?)";
PreparedStatement ps;
Connection sconn;
try{
sconn = DBConnect.getConnection(); //connect to the database
//sconn.setAutoCommit(false);
s = sconn.prepareStatement(sql);
s.setString(1,"ss&s");
s.executeUpdate();

The above will insert the value "ss&s" into the row. This works for all special characters.
Jamie