Diana Robete

database advise, step by step guides, how to emails

What Are Single Row Functions

Published: Wed, 06/22/22

Do you remember what the two main categories of built-in functions are in Oracle? These categories are created based on how many rows these functions…

What Is Deferred Segment Creation?

Published: Mon, 04/11/22

Did you know that deferred segment creation was introduced in 11.2? Some DBAs might not be familiar with this concept at all, even with the newer…

How To Get Historical Row Count In a Table?

Published: Thu, 03/10/22

Have you been in a situation where you had to prove the row count in a table has changed or has not changed? Or,maybe you are just curious to see how…

What Is Oracle’s Identity Column?

Published: Tue, 03/01/22

Did you know about a database feature that was introduced with 12c, but is not widely used? This feature would make the life of developers and DBAs…

How Can NLS_DATE_FORMAT Help You?

Published: Wed, 01/12/22

When you connect to the Oracle database, anything that has the DATE datatype, is displayed in the default format of DD-MON-YY, and no time component.

What Is Oracle Instance Recovery?

Published: Thu, 01/06/22

Oracle instance recovery occurs automatically when you try to startup and open a database that crashed or was shutdown abort. An instance recovery is…

<< First < Previous Next >