I hate that multiple single quote stuff - you can concatenate strings and use chr(39) to build your separate single quotation marks. A few extra keystrokes, but very cut and dry as to what is taking place. There are also several notes on My Oracle Support about how to use single quotes, from one, two, three and four in a row, depending on the context.