Страницы

▼
суббота, 13 июня 2020 г.

CURSOR Expressions Return Wrong Results in 18c/19c

›
That is a wrong results issue I stumbled upon this morning. A developer told me that one of their queries started returning wrong results af...
вторник, 9 июня 2020 г.

OR Expansion and Virtual Columns: Changes in 19c

›
This post is a continuation of my previous one: OR Expansion and Virtual Columns . The last post demonstrated that OR Expansion can somehow ...
четверг, 21 мая 2020 г.

OR Expansion and Virtual Columns

›
The following test case can be used to demonstrate a little peculiarity of the OR Expansion transformation, that was introduced in 12.2. It...
четверг, 30 апреля 2020 г.

Secure Use of Runtime.exec Functionality in Oracle Database

›
Developers wanted to call external programs from the database using a Java class. By default, those commands are run under the database user...
вторник, 3 марта 2020 г.

Using LogMiner to Identify Redo Tag for Transactions

›
I was asked if there is a way to identify what redo tag was set for a specific transaction. There is a document that answers the question ...
суббота, 1 февраля 2020 г.

Tracing SQL Macro Expansion

›
I decided to take a look at what events Oracle provides to diagnose or troubleshoot SQL Macro Expansions. For that, I took almost the same ...
понедельник, 20 января 2020 г.

Bug 30324180 SQL Macro should be backported to 19.5

›
When Oracle released 19.6 release update, I went to the usual My Oracle Support (MOS) note: Database 19 Release Updates and Revisions Bugs F...