What Are Annotations and How to Use Them in Oracle 23c?
November 26, 2023One of the new features of the Oracle 23c is annotations. These were mostly created for developers, but I can… Continue Reading
The place where DBAs grow
One of the new features of the Oracle 23c is annotations. These were mostly created for developers, but I can… Continue Reading
It’s spring time, and that comes with spring cleaning not only your house and closets, but your databases too! What… Continue Reading
The other day, I had an interesting challenge to look at. The maximum number of processes in the database instance… Continue Reading
How do I connect to a PDB? This is a common question among new DBAs, and a valid one indeed!We… Continue Reading
Today’s blog post came to my mind, as I am re-writing some scripts, written by others, with tones of concatenations… Continue Reading
You might be learning something new today, as I did when I ran the DBSAT Oracle utility! In the generated… Continue Reading
Continuing on the blog post series of Single-Row Character Functions, we are going to discuss and learn about the following… Continue Reading
In the single-row functions series, we are going to talk about Character Functions, the ones that manipulate the case. Because… Continue Reading
In the previous post, we started talking about Single Row Functions, which return a single value (row) for each row… Continue Reading
Do you remember what the two main categories of built-in functions are in Oracle? These categories are created based on… Continue Reading