Archives

18 Sep 2024

External Password Store for Oracle Databases

Sometimes we have the need to arrange a set of instructions or scripts on automated processes, E.g when we automate a backup process, or when...

06 Jun 2024

Update Gentoo Linux

Updating Gentoo is an easy process but it requires manual intervention, as with this distribution, it's very important to not skip any error and always...

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