Jeff Kemp on Oracle

The latest AI models are remarkably capable; but they’re not perfect.

To sort strings in SQL is fairly straightforward: select * from mytable order by name; This uses the default collation which is at its core based on a character-by-character comparison, which almost always matches what humans would consider to be the “rig…

This is a little tip you might find handy.

We have a number of utility packages that deal with dates and timestamps and we create automated unit tests for them using utPLSQL which is an excellent unit test framework for PL/SQL.

Got a lot of APEX applications, and/or a schema with lots of objects?

Wherein I natter on about gear and how I choose what to buy.

This would be a very rare requirement, as most of the time when you are designing an ORDS REST service you should know what query parameters your service supports.

The Oracle JSON functions are very useful for generating JSON from a query, and developing using these functions requires understanding the limitations of the string data types they return.

If you wish to remove a NOT NULL constraint from a column, normally you would execute this: alter table t modify module null; The other day a colleague trying to execute this on one of our tables encountered this error instead: ORA-01451: column to be mod…

Quite often I will need to export some data from one system, such as system setup metadata, preferences, etc. that need to be included in a repository and imported when the application is installed elsewhere.