Страницы

▼
понедельник, 9 сентября 2019 г.

APEX WWV_FLOW_SECURITY.GET_OWNER_OF_CALLING_CODE and 12.2

›
Our developers were using WWV_FLOW_API.SET_SECURITY_GROUP_ID and were surprised to find that that procedure behaves differently in 12.2 tha...
воскресенье, 8 сентября 2019 г.

Unwrapping PL/SQL: Using Custom Wrap Tables

›
The previous article in this series: Unwrapping PL/SQL: a Systematic Approach As a bonus, I decided to apply that discovered knowledge ab...
пятница, 6 сентября 2019 г.

Unwrapping PL/SQL: a Systematic Approach

›
The high-level steps of how PL/SQL code appears to be wrapped since 10g on are below: The source code is normalized (converted to upper-ca...
среда, 4 сентября 2019 г.

Bug 26588069 - Wrong Result (Duplicate Rows Produced) Using Group By After Upgrading To 12.2.0.1

›
I have stumbled upon this bug after upgrading one of my databases to 12.2.0.1. Here is a simplified test case: SQL> create table gby_el...
четверг, 15 августа 2019 г.

Starting Oracle Database on Demand Using Socket Activation

›
I remember watching a video about Amazon Aurora Serverless where it was demonstrated that your database can be started on demand when the f...
пятница, 9 августа 2019 г.

That Old Restart Problem Strikes Back: Triggers to the Rescue

›
The previous articles in this series: 1. That Old Restart Problem Strikes Back: Setting the Stage 2. That Old Restart Problem Strikes Back...
пятница, 2 августа 2019 г.

That Old Restart Problem Strikes Back: Getting What You Pay for

›
The previous article in this series: 1. That Old Restart Problem Strikes Back: Setting the Stage During my previous research, I was also ...