Oracle Database: Get it Right
The latest AI models are remarkably capable; but they’re not perfect. So how do you use AI for coding without letting it go off the rails? First, let’s get a few things out of the way. I do not use AI to write my articles for me. I do use AI for coding but [ ]
To sort strings in SQL is fairly straightforward: 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 right order unless decimal numbers are found, in which case this will sort strings like abc-2000 before abc-30 . Natural Sort, [ ]
This is a little tip you might find handy. Every typical database stores important strings like place names that are then displayed in reports and charts. Most of the time these strings are relatively short (e.g. 30-40 characters) and the reports and charts look fine, but occasionally some records happen to require a much longer [ ]
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. These unit tests are executed by our automated scripts whenever we merge changes into our git repository; this gives us early warning if [ ]
If your answer to any of the above is Yes , you may be interested in a new API that has been added in APEX 24.1 and updated in 24.2. You can use this API to scan your application for any references to any schema objects, whether it refers to objects in a region, SQL queries, [ ]
Wherein I natter on about gear and how I choose what to buy.Perhaps with a point to make about software development. At least once a year we pack the Prado with a tent, gear and food and go camping with a group of friends. For a few days to a week or so we d unplug, [ ]
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. However, in the case where your users are allowed to supply an arbitrary list of additional parameters to your service, you won t know what the keys [ ]
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. Unless otherwise specified, they return a VARCHAR2 with a maximum of 4000 bytes. If your query might return more than this, you must either specify a [ ]
If you wish to remove a NOT NULL constraint from a column, normally you would execute this: The other day a colleague trying to execute this on one of our tables encountered this error instead: Most of the time when you see this error, it will be because of a primary key constraint on the [ ]
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. I might export the data in JSON or CSV or some other text format as a CLOB (character large object) [ ]