¿Query dinámico?, pero sin perder de vista el contexto

Es relativamente frecuente que tengamos que recurrir a SQL dinámico cuando no sabemos en tiempo de compilación el texto completo de la sentencia. Si bien en los tiempos de Oracle 7 la única forma de lograrlo era usando dbms_sql, en la actualidad la forma preferida de procesar SQL dinámico es con execute immediate, el problema radica en que no se hace buen uso de él y se termina generando código no reutilizable y (more...)

Available January

I've just discovered that my current contract, with a healthcare company in Hampshire, will not be extended beyond the end of the year. So, in the current economic climate, I've decided to start a blog in order to drum up more business.

My primary skills are in troubleshooting and tuning Oracle systems, from entire databases to individual SQL queries.

If you have an application running on an Oracle database and you need someone to investigate an issue on that system, get in touch.

"My name is Peter Moore. I am a professionally qualified and highly experienced database administrator with extensive (more...)