(savvinov) In this article, I’ll summarize my observations regarding nested loop join mechanisms as well as previously known facts, so that everything would be in one place.
Tag: Oracle
SELECTs Do Not Block UPDATEs
(Andrew Reid) I went on my first DBA course in 1997 and the lecturer there explained that readers do not block writers in an Oracle database. I had an issue recently which appeared to contradict this so I have reproduced it below in an Oracle 11.2.0.1 database.
Master – Detail synchronization in an Oracle JET rich client application against a REST API
(Lucas Jellema) In a recent article (Extend Oracle JET with Table on REST API and Deploy to Node.js in Application Container Cloud) , I have described how I created a data bound Oracle JET application with a rich JET table component that reads its data from a REST API (that gets it from a DBaaS inst
When JET Comes To Rescue – Live Data Charts in ADF
(Andrejus Baranovskis) I have described previously, how you can run JET in ADF UI – Improved JET Rendering in ADF.
Public / private cursors
(connormcdonald) As we all know (hopefully), we should always deploy named program units (procedures/functions) within packages. Its a great method of encapsulation of logic.
Function That Returns a Compass Point From a Whole Circle Bearing
(Simon Greener) This article shows how to create a compass point from a whole circle bearing.
if you write SQL, be specific!
(Martin Berger) Today I got a ticket from a developer where he claimed Oracle has a bug somewhere. The reason for this claim was a statement similar to
Extend Oracle JET with Table on REST API and Deploy to Node.js in Application Container Cloud
(Lucas Jellema) In this article, I will describe how I took the Oracle JET Sample application that I deployed to Node.js – locally and in the Oracle Application Container Cloud-and extended it with a new tab containing a table component that is data bound to a collection populated from a REST API th
COMPRESSION — 2 : Compressed Table Partitions
(Hemant K Chitale) A Partitioned Table can choose to have a mix of COMPRESS and NOCOMPRESS Partitions.
Chunking tables 8: second solution
(stewashton) Here is the second complete solution to the problem of dividing a table into chunks of equal size. This is the solution whose first version was marked “correct” on OTN.
