(Jeffrey Kemp) There is a great deal you can build in APEX without even thinking about using a plugin. The development platform has an excellent range of built-in functionality and components so that almost all user requirements can be covered using standard APEX features.
Community
Oracle internal data dictionary oddity
(Frits Hoogland) This blogpost is about an inconsistency I found in the X$ tables X$KQFTA and X$KQFCO. This is very specific. If you don’t care about that, you can skip this post.
Database Link to 9.2 Database from 19c
(Bobby Durrett) I have mentioned in previous posts that I am working on migrating a large 11.2 database on HP Unix to 19c on Linux.
UNION vs. UNION ALL in SQL Server
(Greg Robidoux) Sometimes there is a need to combine data from multiple tables or views into one comprehensive dataset. This may be for tables with similar data within the same database or maybe there is a need to combine similar data across databases or even across servers.
Client-Side Caching In Angular 8 Using HTTP Interceptor
(Sarathlal Saseendran) In this post, we will see how to achieve client-side caching in Angular 8 application using HTTP Interceptor. We will create an ASP.NET Core 3.0 application with SQL server as backend to save and retrieve the employee data.
Db2 SQL for the DBA – Using Modern SQL for DBA Tasks
(Brian Laube) Recent releases of Db2 have introduced new SQL functionality that improves the functionality and productivity of application developers. But the DBA can also take advantage of some of the “new” Db2 SQL to improve their own productivity.
Who needs data access? Not You!
(Jason Brimhall) Does this sound at all familiar? A user submits a request stating they must have elevated access to a database. In your attempt to gather more information about the request, they must have access because so-and-so has elevated access and they are curious about the database.
What happens if I disable the clustered index?
(Kenneth Fisher) You are probably already aware that you can disable an index. This can be handy when you have a large load and the load + re-enabling the indexes (you have to completely rebuild them) is faster than leaving the indexes in place.
Continuous integration with Jenkins
(Steven Haines) Looking back at how software was built and deployed even 15 years ago, it seems surprising that our applications actually worked.
Using Resource Files In Razor Pages Localisation
(Mike Brind) This is the second in a series of articles that cover localisation in ASP.NET Core Razor Pages applications. In the previous article, I looked at the basic configuration required to work with cultures which are the basic building block of localisation.