Pure Performance Inc

At least once in your career you will have to deal with duplicate rows causing havic on you application. This post will help you get through that delema. I have Oracle and MySql examples below.

During development things always change. Column names change, columns may be added or removed from tables and so on. When this happens, you need to go back to your PL/SQL programs and change the code. In some cases, you can just recompile the package or procedure to find the problems caused. But that doesn’t always catch everything, especially when you have dynamic SQL. So you should always run a PL/SQL search to find the column or text that has changed.

Welcome to the updated site of Pure Performance Inc.  This site will be used to update our clients and clients to be  with our current activities.  We will also be providing tips and tricks for PeopleSoft, Oracle, Web, & UNIX developers. Enjoy -Mark