September 2022 - Page 3 of 3

ORA-32001: write to spfile requested but no SPFILE specified at startup !!!!

ORA-32001: How to identify if the database was started with spfile or pfile? There are couple of ways of finding if the database was started with spfile or pfile. First…

asrblogger September 17, 2022No Comments

Oracle SQL

ROWID Pseudocolumn

For each row in the database, the ROWID pseudocolumn returns the address of the row. Every table in an Oracle database has a pseudocolumn named ROWID. Oracle Database rowid values…

asrblogger September 17, 2022No Comments

Oracle SQL

SQL New Features in Oracle Database 19c

SQL Macros You can create SQL macros (SQM) to factor out common SQL expressions and statements into reusable, parameterized constructs that can be used in other SQL statements. Starting with…

asrblogger September 9, 2022No Comments

Oracle

19c New Features

In this article, we’ll discuss 5 new features and functionality of Oracle Database 19c that will have you not just ready, but excited for your next Oracle database upgrade. 1.…