What Are Single Row Functions
June 20, 2022Do you remember what the two main categories of built-in functions are in Oracle? These categories are created based on… Continue Reading
READ vs SELECT Privilege
April 14, 2022Are you aware of the READ object privilege in Oracle? If yes, what was your first thought of it when… Continue Reading
What Is Deferred Segment Creation?
April 11, 2022Did you know that deferred segment creation was introduced in 11.2? Some DBAs might not be familiar with this concept… Continue Reading
What Is The Difference Between Oracle Table And Oracle Segment?
March 17, 2022DBAs use these two concepts interchangeably: table and segment, more precisely table segment. Why is that? When we think of… Continue Reading
How To Get Historical Row Count In a Table?
March 12, 2022Have you been in a situation where you had to prove the row count in a table has changed or… Continue Reading
What Is Oracle’s Identity Column?
March 1, 2022Did you know about a database feature that was introduced with 12c, but is not widely used?This feature would make… Continue Reading
How Can NLS_DATE_FORMAT Help You?
January 12, 2022When you connect to the Oracle database, anything that has the DATE datatype, is displayed in the default format of… Continue Reading
What Is Oracle Instance Recovery?
January 6, 2022Oracle instance recovery occurs automatically when you try to startup and open a database that crashed or was shutdown abort.… Continue Reading
3 Datapump Parameters That Will Change Your Life
December 14, 2021Did I get your attention with the title? Well maybe these parameters are not really life changing, but at least… Continue Reading
How To Allow Blank Lines In Your SQL Statements: SQLBLANKLINES
November 2, 2021Today’s post will give you a quick and easy tip. Did it ever happen to you to receive a script… Continue Reading