||Ruby/Tk Primer: Creating a cron GUI Interface with Ruby/Tk|
Response to: About String
Ok, it's been quite a while since I've done any SQL, but if I remember correctly, the problem you're running into has to do with SQL's use of the single quote ('). In this case I believe the database assumes that the single quote (or, aposrophe) you have in your statement "shy's" is a delimiter. I think you can can make the DB treat it as part of the string by replacing the single quote with two single quotes. So, instead of "shy's", try "shy''s" (two single quotes, not a double quote). If that doesn't work, then you may have to take a look at the documentation for Oracle to see how you tell the DB that the single quote is not a delimiter, but part of the string instead.
Hear us Roar