more Oracle head bashing

Today I have been having ‘fun’ trying to put multi-line text into Oracle SQL scripts. Now, this snippet works fine in SQLPlus: UPDATE email_templates SET email_content = ‘Hello. Blah blah blah. Goodbye.’; But this one barfs when it gets to the first blank line: UPDATE email_templates SET email_content = ‘Hello.   Blah blah blah.   […]

sql whinge

In SQL, when you add a column to a table, you just say ‘add’, e.g. ALTER TABLE my_table ADD my_new_column VARCHAR(12); But if you want to remove a column you have to say ‘drop column’, like this: ALTER TABLE my_table DROP COLUMN my_old_column; This is one of those little inconsistencies that drives me mad – […]

unfriendly Oracle

17:21:13,907 ERROR [Transaction] [TP-Processor5] Could not create entity java.sql.SQLException: ORA-01401: inserted value too large for column Yes. I wish you would tell me which column. That wouldn’t be too hard, now would it?