Search for a command to run...
Articles tagged with #oracle-database
About five years ago, while developing a CRM module, I needed to implement a field where the salesperson could describe the entire conversation they had with a customer. Initially, I went with the obvious approach and created a VARCHAR2(4000) column....
![Something Between VARCHAR2 and CLOB: VARCHAR2 on Steroids [MAX_STRING_SIZE]](/_next/image?url=https%3A%2F%2Fcdn.hashnode.com%2Fres%2Fhashnode%2Fimage%2Fupload%2Fv1760047927511%2Fd21b9892-29f1-42bc-8e1b-7c2b4d0a642d.png&w=3840&q=75)
After a lot of reading, trying to understand, testing, and getting beat up by the tool, I finally managed to make a simple CI/CD process work between development and production. I can now generate releases from the development database that can be ap...
Sometimes, when comparing strings in Oracle, we want to ignore whether the text is in uppercase or lowercase, or whether it includes accent marks. For that, Oracle provides a feature called COLLATE, which can be applied at the table, session, or quer...
Sometimes at work, two developers end up editing the same package almost at the same time. One of them had been working on it since early afternoon, compiling along the way. The other opened the package body in the morning, made some changes at the e...
I’ve often needed to deal with wallets in the database without having SSH access. So, to use mkstore or orapki locally, I had two main options: either download a database version and install it on a VM or local machine, or download and install the fu...
