(Sven Weller) The APEX 19.2 readme includes info about a small script check_lovs_for_errors.sql that one should run after the upgrade. It is very easy to overlook this in the readme files.
Other News
How to show dates in a given time zone when the value is stored in a DATE data type
(Joel R. Kallman) Firstly, this post has nothing to do specifically with APEX. It has everything to do with date conversions in Oracle SQL and how to convert them to a different time zone.
AWR records top 30 SQLs by default
(Bobby Durrett) I forget that Oracle’s AWR only records the top 30 SQL statements in each snapshot by default. I am not sure how long this link will last but here is a 19c manual page describing the default: 19c manual – see the topnsql setting.
Working with IWebHostEnvironment and IHostingEnvironment in dual targeted ASP.NET Core Projects
(Rick Strahl) With .NET Core 3.1 Microsoft broke a fairly low level abstraction by effectively renaming IHostingEnvironment and replacing it with IWebHostEnvironment. IHostingEnvironment still exists in .NET Core 3.x and can still be used and it still works, but it’s been marked as deprecated and wi
Understanding the Utility of Iostreams in C++
(Manoj Debnath) The iostream classes are the first library classes we encounter when we begin with C++. The primary services that we deal with these classes is solving general I/O problems.
ML.NET Model Builder for Machine Learning Adds Recommendations
(David Ramel) Microsoft’s latest update of ML.NET Model Builder adds a recommendation scenario to the machine learning (ML) framework, along with image classification model training functionality.
Db2 for z/OS: Clearing Up Some Matters Pertaining to 10-Byte RBA and LRSN Values
(Robert Catterall) At this time, many Db2 for z/OS-using organizations have already completed their migration to Db2 12. Others are still in the process of accomplishing that migration, or are finalizing migration plans.
MySQL Table can have the WASTED/FRAGMENTED space without data deletion ( DELETE ) ?
(Sri Sakthivel Durai Pandian) Yes, INSERT’s with the ROLLBACK can also create the table fragmentation . In this blog I am going to explain how the INSERT is causing the table fragmentation .
SQL SERVER – Top Reasons for Slow Performance
(Pinal Dave) Yesterday, I had asked a very simple question on twitter about the top reasons for the slow performance. I had received a lot of interesting answers and perspectives on that topic. Lots of people also sent me a detailed email as they thought there is not enough space to type the answer
Handling Events In Kendo SpreadSheet Using jQuery
(Gowtham K) Basically, JavaScript interacts with HTML though events, and different types of events will be fired when the HTML page loads.