Flavio Casetta

Subscribe to Flavio Casetta feed
Welcome to Flavio Casetta's official Oracle database application development related blog. No Mysql supporters were hurt in the making of this blog.
URL: https://oraclequirks.blogspot.com/
Updated: 11 hours 35 min ago

Setting the CARDINALITY (undocumented) hint on two tables

Tue, 2024-03-26 09:02
Categories: DBA Blogs

Order of appearance of functions and subqueries in a WITH ... SELECT

Fri, 2024-03-15 05:53
Categories: DBA Blogs

When #OWNER# is not the OWNER you expected

Tue, 2024-03-05 08:24
Categories: DBA Blogs

APEX Master Detail side-by-side form ICON_CLASS and ICON_COLOR_CLASS explained

Thu, 2024-02-29 04:30
Categories: DBA Blogs

APEX feature request, support needed!

Tue, 2024-02-20 01:10
Categories: DBA Blogs

ORA-14148: DML and DDL operations are not directly allowed on the guard-column.

Tue, 2024-01-16 09:18
Categories: DBA Blogs

Resetting system generated sequence numbers for identity columns

Fri, 2024-01-12 10:33
Categories: DBA Blogs

Getting all the simple combinations of n elements with a query (and what to do next)

Mon, 2023-12-11 01:10
Categories: DBA Blogs

Handling XLIFF documents generated by Oracle APEX

Tue, 2023-10-31 04:52
Categories: DBA Blogs

ORA-00942: table or view does not exist on inserting rows with a user other than the table owner

Tue, 2023-09-12 09:16
Categories: DBA Blogs

In a single-byte character set database non-ASCII characters may cause JSON parse to fail

Mon, 2023-07-31 10:30
Categories: DBA Blogs

Weird behavior of UPDATE when a SDO_GEOMETRY column needs to be updated

Tue, 2023-07-04 05:36
Categories: DBA Blogs

Handling of non-ASCII characters in JSON objects in a non-AL32UTF8 database

Wed, 2023-05-31 08:29
Categories: DBA Blogs

Fixing the SRID in a spatial geometry column

Tue, 2023-05-30 07:02
Categories: DBA Blogs

Yet another curious syntax with little documentation: SELECT FROM RELATIONAL("schema"."table")

Fri, 2023-03-10 07:05
Categories: DBA Blogs

The strange case of ORA-01841 and ADD_MONTHS

Mon, 2023-03-06 06:29
Categories: DBA Blogs

The strange case of the REVERSE function

Wed, 2022-10-26 04:30
Categories: DBA Blogs

Excel's "The file is corrupt and cannot be opened"

Thu, 2022-05-12 07:30
Categories: DBA Blogs

Oracle XE21C and RHEL8 preinstall rpm wrong address

Sun, 2021-11-14 10:34
Categories: DBA Blogs

JSON_QUERY behavior in SQL vs PL/SQL (Oracle 12.2 only?)

Thu, 2021-06-03 02:59
Categories: DBA Blogs

Pages