Diana Robete

database advise, step by step guides, how to emails

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…

Is the FROM Clause Really Optional?

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.

4 Steps to Spring Clean Your Databases

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…

4 Steps to Spring Clean Your Databases

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!…

4 Ways of Connecting to a PDB

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…

SQLPLUS’ Forgotten Option: COLSEP

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…

What Is the Become User Privilege

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…

<< First < Previous Next >