the statement parser needs to know how to put in two single
quotes for any single quote it encounters within a string
literal. This is necessary since oracle uses the single quote
as the string terminator. These are some examples of single
quotes that would need to be replaced:
update test set testcol = 'It's a test';
update test set testcol = '''''''' test';
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Logged In: YES
user_id=573769
the statement parser needs to know how to put in two single
quotes for any single quote it encounters within a string
literal. This is necessary since oracle uses the single quote
as the string terminator. These are some examples of single
quotes that would need to be replaced:
update test set testcol = 'It's a test';
update test set testcol = '''''''' test';
Logged In: YES
user_id=573769
hopefully this can be easily accomplished using some
powerful regular expressions and the jdk1.4 String method
replaceAll()