Useful Examples For DBAs of Single Row Numeric Functions
Published: Fri, 08/26/22
In the previous post, we started talking about Single Row Functions, which return a single value (row) for each row of a queried object, basically…
database advise, step by step guides, how to emails
Published: Fri, 08/26/22
In the previous post, we started talking about Single Row Functions, which return a single value (row) for each row of a queried object, basically…
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…
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…
Published: Thu, 03/17/22
DBAs use these two concepts interchangeably: table and segment, more precisely table segment. Why is that? When we think of tables, we think of the…
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…
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…
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.
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…
Published: Wed, 12/15/21
Did I get your attention with the title? Well maybe these parameters are not really life changing, but at least very helpful! When I learned about…
Published: Tue, 11/02/21
Today’s post will give you a quick and easy tip. Did it ever happen to you to receive a script from a developer, that contains many blank lines within…