Skip to Main Content

New to Java

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to include '+' symbol in the string

807601Mar 23 2008 — edited Mar 24 2008
Dear Experts,

I am using the following query:

strQuery = " INSERT INTO master_table (numeric_id, full_name) values (SELECT CASE WHEN MAX (numeric_id) IS NULL THEN 1 ELSE MAX (numeric_id) + 1 END,'My Name')";*

As an output for the above string the '+' is missing with gives an error as a syntax error of this query.

Any suggestion will be appreciated
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 21 2008
Added on Mar 23 2008
10 comments
213 views