We all read the blog postings about what features were added in Oracle APEX 4.1, like the ones here, here, here and here. But what does that mean on a more technical level? Which Views have changed, which API’s have changed? Inspired by the webinar over here I thought I’d give the Red Gate Schema Compare Tool a try.… Read more
Understanding is required before success is possible [Dune] old Orange Catholic Bible When you want to hide and display certain regions in an APEX based application based on the selection of the user, for instance when a button or a link is pressed then you can of course use the Region Display Selector, but this takes up a region on… Read more
A few months ago we (APEX Evangelists) launched the APEX Challenge, a weekly quiz where you get a question about Oracle Application Express. Next to the fun of answering the questions and see your rank, you will hopefully learn something.… Read more
Psst, wanna see something cool? I bet I can read your future. Your tomorrow is going to be almost exactly like your today; unless it’s a weekend, in which case it’ll be almost exactly the same as last weekend. You’re welcome: that’ll be ten quid. It is a truth that life’s events – and, by extension, computer operations – ar… Read more
Enterprise Manager Cloud Control is the new name for what was previously know as Enterprise Manager Grid Control. Depending on the source of the material, you may still see the product described as Grid Control. This article (read it in full on Oracle-Base.com) describes the installation of Oracle Enterprise Manager Cloud Control 12c Release 1 on Oracle Linux 5.7 and… Read more
Forms was a great tool and stood for fast and easy development. You could create nice data entry applications in no time. But now some people think Forms is dead, it doesn’t have a future or it is at the end of its lifecycle. In this article I hope to prove they’re wrong. And unlike the first sentence to prov… Read more
With the recent announcement of the Oracle Database Cloud, it also means Oracle gives a strong message towards the APEX community. Oracle Application Express (APEX) will be included in the Database Cloud.… Read more
You know the story. A group of blind men come across an elephant and each one feels a part of it. One touches the tusk and goes away thinking elephants are pointy, hard and sharp; another feels its side and is amazed at how wide and featureless elephants are; and one unfortunate man feels the elephant up its backside,… Read more
The process of learning requires not only hearing and applying but also forgetting and then remembering again. – John Gray Sending data back Using the bulk capabilities you can not only fetch data in one roundtrip to the database, but you can also use it to send data back to the database in a single roundtrip. Using the FORALL statement… Read more
Posted by Gert Poel on the the iAdvise blog: I want to call all Oracle Forms developers and administrators to fill in this online survey about Oracle Forms. The results will be published during Oracle Open World. I’m interested in this topic (Forms and Forms Modernization) and I will be delivering a presentation at Oracle Open World about Oracle Forms(session… Read more
Recently I was asked to create some merchandise that fell outside of my norm. Specifically, I was asked to create a onesie, or piece baby outfit. I tried using my normal method of creating a simple png (pixel) graphic in gimp, however, when I tried to add that to something other than a regular old t-shirt, the application didn’t giv… Read more
As you know (or may not know) there are two engines running in the Oracle database. The PL/SQL engine for executing all your PL/SQL code and the SQL engine for executing all you SQL statements. This means that every time your PL/SQL code needs data from the database, or writes to it control is passed from the PL/SQL runtime engine to the SQL.… Read more
A quick puzzle from Alex Nuijten’s blog: How long is the folowing string?: to_char (10, ‘0999’) Have a think, and then check out the answer on nuijten.blogspot.com.
… Read more
Dynamic SQL is a powerful tool. In its proper place it can achieve quite a bit of work in a relatively small amount of code. Used improperly, however, it can cause all sorts of code maintenance headaches. Consider the following procedure. It uses the HR schema and sample data that comes with an installation of the Oracle database: CREATE OR… Read more
From Geoff Hudik’s blog. As part of my recent role in application release management, I have had to compare and sync various objects across Oracle databases. This was not fun work and I decided to evaluate some different tools to make this easier. The tool I have been working with recently is Red Gate’s Schema Compare for Oracle. In this… Read more
Recently I had an inquiry via my website asking whether I was able to create a selectable body chart APEX plugin for a physiotherapy practice so they could easily highlight joint pain and record information against these selected areas. One of the challenging requirements was to allow fine grained selectivity of 16 areas on each…
… Read more
Regular expressions – RegEx or RegExp to their friends – were fashionably late in coming to the Oracle party. The seeds of what we know today as regular expressions were formulated in the period immediately following the Second World War in fields as diverse as formal language theory and neurophysiology; but it wasn’t until the PL/SQL Web toolkit arrived for… Read more
“The process of learning requires not only hearing and applying but also forgetting and then remembering again.” John Gray. This article follows on from Collections in Oracle Part 1 Varray The syntax for defining a varray in SQL is like this: CREATE OR REPLACE TYPE varray_type AS VARRAY(SIZE) OF element_type; The syntax for defining a varray in PL/SQL is lik… Read more
The business rule states: Only one entry is allowed per ID and per day and the time should be recorded. The table involved (simplified for the blog post) Wouldn’t it be nice if it was possible to do it like this? This way you still have the complete date information (time is a component of the date column), and only… Read more
Redgate Deploy is the solution to automate database deployments so that software can be delivered more frequently and reliably. From versioning to Continuous integration and repeatable deployments, Redgate Deploy enables Continuous delivery of database changes for SQL Server, Oracle and 18 other databases.