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: 3 hours 39 min ago

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

JSON get_Date() method always discards time portion

Thu, 2019-05-16 08:46
Categories: DBA Blogs

Mystery and imagination of DELETE RETURNING INTO

Thu, 2019-02-07 09:55
Categories: DBA Blogs

ALTER SESSION RESET parameter works but doesn't work

Thu, 2019-01-10 04:51
Categories: DBA Blogs

ORA-01720: grant option does not exist for SCHEMA.TABLE

Thu, 2018-11-15 03:32
Categories: DBA Blogs

Pages