(amitzil) This topic has been sitting in my backlog for a long time and I finally decided to write it. Analytic functions are not so new anymore (they’ve been around since Oracle 8i), but they are still a very powerful tool.

(Peter Raganitsch) Oracle APEX offers a declarative setting for Text and Textarea items to “Trim Spaces”, which would remove leading/trailing spaces from the user input before saving the value to the database.

(kevinclosson) This is a quick blog post in response to a recent interaction with a SLOB user. The user reached out to me to lament that all her file system space was consumed as the result of a SLOB execution (runit.sh).

(Lucas Jellema) Oracle APEX is a low code application development framework. It can be used free of charge – either as part of an existing Oracle Database license or running in the free Oracle Database 18c XE product.

(Martin Berger) Last week during a discussion with a colleague we thought if it would make sense to have in SQLDeveloper the possibility to see the system “as it was some minutes ago”.

(Martin Bach) In the past few months I have spent considerable amounts of time working on new technology (new as in “new to me”) and one of the things I have found a great interest-and more importantly-use cases with, is ansible.

(Uwe Hesse) The result of a query can be cached in Exasol to the effect that repeated identical queries complete in no time.

(Mohamed Azar) When I try to open forms, I am getting the below issue

(Hemant K Chitale) Interval Partitioning was introduced in 11g as an enhancement to Range Partitioning, but supporting only DATE and NUMBER datatypes.

(Scott Wesley) I’ve been using the lazy loading concept demonstrated in Maxime’s post quite a lot recently, I’d love to see this as a declarative feature one day.