How To Use Character Functions That Manipulate The Case
September 1, 2022In the single-row functions series, we are going to talk about Character Functions, the ones that manipulate the case. Because… Continue Reading
Tag: DBA
Useful Examples For DBAs of Single Row Numeric Functions
August 26, 2022In the previous post, we started talking about Single Row Functions, which return a single value (row) for each row… Continue Reading
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
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
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
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
How To Synchronize Applications
September 27, 2021In previous blog post we talked about maintenance in the application root container. If you remember, I mentioned that the… Continue Reading
Application Upgrade inside the Application Root Container
August 2, 2021In the previous post, we talked about application maintenance within an Application Root Container, specifically an application installation. As promised,… Continue Reading
When to use MAX_PDBS parameter
March 16, 2021MAX_PDBS parameter was introduced in 12cR2, to limit the number of pluggable databases (PDBs) one can create in a CDB… Continue Reading