Monthly Archives: April 2009

Personal Names

Posted on 17 April, 2009 by Simeon

Made a weird discovery this week, my neighbour and I both share the same spelling of our names yet they are pronounced differently. I’m Simeon (sim-e-on) and he is Simeon (sime-on the same as the name Simon),  so weird to … Continue reading →

Posted in Uncategorized | Leave a comment

When removing columns rebuild your views

Posted on 3 April, 2009 by Simeon

If remove a column from a table in your Oracle DB, and you have a views that select * from tablename, you need to recreate the view. I was comparing my old schema and new schema, and had all the … Continue reading →

Posted in SQL | Leave a comment