Archives
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...