If you don’t ask, you will never find out why your system is performing poorly

Posted on April 19, 2013 by Paul Dorsey — 2 Comments ↓

We had a large operation that took up to a minute to run. It was copying data to a staging area, running over a thousand data validation rules (~50,000 lines of code), and then formatting all of the validation errors…

Tagged with: performance tuning, PL/SQL
Posted in BLOG, PL/SQL, SQL

Case-sensitive object names

Posted on February 25, 2013 by Ileana Balcu — No Comments ↓

A tip/funny story from our colleague Grigoriy Novikov: There was one project with which I was involved that required a lot of different tools used by a lot of developers with different fields of expertise. The Java developer group was…

Tagged with: Database, Oracle, SQL, table, Table (database)
Posted in Code tips, Consulting, Resources, SQL

Creating a comma-separated list of items from a column

Posted on August 1, 2011 by Ileana Balcu — 2 Comments ↓

We needed to create a comma-separated list of items out of a column. We wanted “Red,Orange,Blue,Black,White”, and in the database we had Red Orange Blue Black White Grigoriy Novikov came up with a number of solutions: Solution 1: The basic…

Tagged with: Database, Grigoriy, Oracle, Oracle Database, PL/SQL, Select, SQL, tips
Posted in BLOG, Code tips, Oracle, PL/SQL, SQL

Installing Oracle 32b Development tools in Windows 7

Posted on July 22, 2011 by Ileana Balcu — No Comments ↓

If you are trying to install some of the Oracle Development Tools (Oracle Forms, Oracle Reports, Oracle Designer) in a Windows 7 environment and you need access to the Registry, you can find those entries by using regedit in the…

Tagged with: Oracle Designer, Oracle Forms, Oracle Reports Builder, registry, Windows7
Posted in BLOG, Code tips, Consulting, Oracle, PL/SQL, SQL