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: http://oraclequirks.blogspot.com/
Updated: 14 hours 52 min ago

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

Oracle Spatial, dynamic SQL, a view and the strange problem of a SDO_GEOMETRY bind variable

Thu, 2020-06-25 09:22
Categories: DBA Blogs

ORA-40478: output value too large (maximum: )

Fri, 2019-12-13 06:35
Categories: DBA Blogs

GRANT INHERIT PRIVILEGES

Mon, 2019-10-28 04:58
Categories: DBA Blogs

Pretty print JSON strings in Oracle 12.2 the easy way

Thu, 2019-10-10 06:55
Categories: DBA Blogs

How to rename an oracle scheduler job

Thu, 2019-10-03 14:07
Categories: DBA Blogs

JSON, the Euro symbol and a WE8MSWIN1252 character set database

Tue, 2019-07-30 08:53
Categories: DBA Blogs

Houston, we've got a problem with JSON PUT method

Wed, 2019-07-03 04:43
Categories: DBA Blogs

Nice bug in Oracle 12.2.0.1 affecting function NUMTODSINTERVAL

Tue, 2019-06-11 09:54
Categories: DBA Blogs

Pages