You are here |
chandlerdba.com | ||
| | | |
mikedietrichde.com
|
|
| | | | If you still use DBMS_JOB in Oracle Database 19c, you will need this important one-off patch to avoid hang situations. This applies till 19.7 | |
| | | |
connor-mcdonald.com
|
|
| | | | Anyone who read Animal Farm as a school student, will remember the famous line: "All animals are equal, but some animals are more equal than others" The concept of equality has been the same with database transactions since databases began. We all have equal rights in being able to lock a row for our exclusive... | |
| | | |
mikedietrichde.com
|
|
| | | | Come and meet us at our Upcoming In-Person Workshops in May 2024 in Copenhagen, Stockholm and Frankfurt - Upgrade / Migration / Patching | |
| | | |
jonathanlewis.wordpress.com
|
|
| | Here's a little thing that Dan Morgan mentioned to me some time ago. It's a little routine from a package (owned by sys) that appeared in 11.2.0.3 that gives you some idea of the mess hidden behind a query that uses views. The procedure is called dbms_sql2.expand_sql_text and it takes two (CLOB) parameters: an IN |