Search for a command to run...
Articles tagged with #oracle-database
You're already using SQLcl, but your terminal looks plain. I'll show you how to make it more appealing—nothing complicated, just simple enhancements. While SQLcl has many parameters, which are the mos
In my previous blog post (link), you learned about Loki and how it can help you avoid conflicts in a shared Oracle development database. Now it’s time to learn how to install & set up Loki in your database. Requirements APEX 24.1.7 - Loki’s last vers...
What is a proxy user? If you use a proxy user, you can connect to another database user without knowing their password. Why use a proxy user? I believe (and I’m not the only one) that giving developers, such as John and Rafal, passwords to, for examp...
I needed to set maintenance mode for my 15 APEX applications in the production environment. Typically, the process is simple - just set Application Definition - Status to “Unavailable”: And your users will be logged out and will see this ugly, defau...
In this article, I will give you a general idea and test the basic functionalities of a tool called D.O.M.E - Deployment Organization Made Easy. The tool was created by Zoran Tica, whom I met at the APEX Alpe Adria conference in 2023 (I promised him ...
Introduction Welcome to part 3 of "A whirlwind tour of Database Schema Changes Tracking Tools." Today, we're diving into the world of Flyway community edition, which is used with Oracle Database. If you want to learn more about the test prerequisites...
