Is the FROM Clause Really Optional?
Published: Wed, 01/31/24
23c New Feature – Alias in the GROUP BY Clause? You read that right! One of the best features of Oracle 23c is the use of aliases in the GROUP BY…
database advise, step by step guides, how to emails
Published: Wed, 01/31/24
23c New Feature – Alias in the GROUP BY Clause? You read that right! One of the best features of Oracle 23c is the use of aliases in the GROUP BY…
Published: Fri, 12/15/23
Is the FROM Clause Really Optional? Did you know that starting with Oracle 23c, the FROM clause is optional? Not totally optional, so let me e plain.
Published: Sun, 11/26/23
What Are Annotations and How to Use Them in Oracle 23c?One of the new features of the Oracle 23c is annotations. These were mostly created for…
Published: Tue, 03/28/23
4 Steps to Spring Clean Your DatabasesIt’s spring time, and that comes with spring cleaning not only your house and closets, but your databases too!…
Published: Thu, 03/23/23
How Many Processes In the Database Historically?The other day, I had an interesting challenge to look at. The ma imum number of processes in the…
Published: Sun, 02/26/23
How do I connect to a PDB? This is a common question among new DBAs, and a valid one indeed!We are all used to connect to a database with the “/ as…
Published: Fri, 01/20/23
Today’s blog post came to my mind, as I am re-writing some scripts, written by others, with tones of concatenations of commas, to obtain a csv file. I…
Published: Wed, 10/12/22
You might be learning something new today, as I did when I ran the DBSAT Oracle utility! In the generated report, I noticed a privilege that was…
Published: Mon, 09/12/22
Continuing on the blog post series of Single-Row Character Functions, we are going to discuss and learn about the following 5 functions: LPAD, RPAD,…
Published: Thu, 09/01/22
In the single-row functions series, we are going to talk about Character Functions, the ones that manipulate the case. Because repetition is the…