Put a DB in Archivelog mode in Oracle
Hello everyone, today we are going to propose a task that when we have an Oracle DB we will have to perform, or at least think about it, which is …
Virtual columns in Oracle. Use and limitations
Hello everyone, today we wanted to refresh with you a utility of Oracle that although it is very powerful we usually use it little, virtual columns . Virtual columns are …
Bug when creating a DB in RAC with dbca
Hello everyone, today we are going to talk about a bug that happened to our team in a client a few days ago. Occurred when creating a DB in RAC …
SQL Macros in Oracle Database 21c
Hello everyone. Today we wanted to discuss with you one of the new functionalities of Oracle 21C (although we have already started to see it from the 20th with limitations), …
Autonumerics: get the latest embedded in Oracle, MySQL, and SQL Server
Hi friends!!! In today’s post we are going to work with Autonumerics in Oracle, MySQL and SQL Server . We will see how to obtain the last value of the …
Cloning from dbca in command mode
Hello everyone, how are you doing? Today we are going to talk again about a feature of Oracle 19c that can be useful when creating new databases. This functionality allows …