Posts by tag: sql

Jun 2025
June 5	When Parallelism Bites - ORA-12860 on a _high Oracle Autonomous DB (OCI)
Mar 2023
March 12	Applying hints to OracleDB subqueries
Oct 2022
October 30	SQL predicates evaluation order
Mar 2022
March 20	Extending locking options with EclipseLink JPQL
March 6	PostgreSQL cursor fetch size (EclipeLink JPA)
Feb 2022
February 20	JPA read-only join table
Jan 2022
January 23	JPA @PostLoad during readOnly (EclipseLink) queries
January 9	JPA (EclipseLink) queries with an unmapped database column
May 2021
May 30	JPQL JOIN FETCH with a condition
May 16	JPQL JOIN FETCH with CursoredStream/ScrollableCursor
Apr 2021
April 18	Native SQL in JPA (EclipseLink) CriteriaBuilder
April 4	JPA (EclipseLink) window functions
Nov 2019
November 17	Snippet for a periodic DB query