13 Mar 2024

Batch processing in Oracle using a single PL/SQL Anonymous Block

As an Oracle consultant a very common activity is to perform commands in batch, for example: rebuild invalid indexes on a given schema, unlock all...

11 Mar 2024

Generate a sequence of numbers using a SQL query

Sometimes we need to generate a sequence of numbers, maybe for cartesian products, or we want to work directly with number series using SQL expressions,...

20 Dec 2023

Hello World!

Be welcome to this site! I am Nicko, The Drako PaxPax and I'll be your host during your stay here. mostly you'll find information about...