Category: Oracle
Hierarchical data is common phenomenon in the real world. Presenting such data to allow users to quickly grasp the composition of numbers, to compare quantities, to navigate through a …
In a recent post (https://technology.amis.nl/2013/07/24/oracle-database-12c-find-most-valuable-player-using-match_recognize-in-sql/) I described how we can use the new Oracle Database 12c MATCH_RECOGNIZE operator to spot patterns in records and derive results from those patterns. …
One of the very nice new features in SQL in Oracle Database 12c is the MATCH_RECOGNIZE operator. MATCH_RECOGNIZE adds a facility for spotting patterns in records. This allows us …
The recent JDeveloper/ADF 11gR1 Patch Set 6 release introduced the Sunburst component, one of the many data visualization components in ADF. Sunburst (sometimes called Rings Chart) provides an attractive …
Last week – just when I was at the far end of a narrow internet connection – Oracle released JDeveloper 12c (12.1.2) along with ADF 12c and WebLogic 12c …
By: Robert van Mölken and Tim Askamp An end-to-end application usually consists of multiple components that are one-way or another decoupled. A component can be an ADF frontend, OSB …
Real time events can be translated into a live visual representation using a largely declarative approach. Events can be published for example on a JMS Topic. Using Oracle BAM …
Flashback started out as a feature in Oracle Database 9i. Although to be honest it is just the opening up of a mechanism that has been at the core …
I am first and foremost a developer. I am not an administrator. I know more about IDEs and GUIs than about command line. I have always been a little …
I have a confession to make. I have not been into Linux very much. When I started my career at Oracle, back in 1994, I had to do a …
When a record is no longer active – it is logically discarded – you may want to delete it. However, the record may still be required – for compliancy …
XMLIndex support for Hash Partitioning is now also supported in Oracle 12c. In Oracle 11 there was already support for RANGE and LIST partitioning, but not yet for HASH …
There is a new default in town. Mark my words, you will encounter the following during your 12c life-cycle… 😉 From the Oracle 12c Reference manual PGA_AGGREGATE_LIMIT: PGA_AGGREGATE_LIMIT PGA_AGGREGATE_LIMIT …
New in Oracle 12c and one of the big new features in XMLDB is the XQuery Full Text functionality and, as mentioned in the post about XQuery Update, is …
New, new…? No, not really new, XQuery Update (W3C standard/draft 2011) was already implemented in 11.2.0.3.0, but is now officially also announced. Besides the XQuery Full Text support (XQFT …
Oracle 8i (8.1.6 if I remember correctly) started with the introduction of a that wonderful new phenomenon in SQL: Analytical Functions. Functions that basically allow the result for one …
Joining is a key ingredient in most SQL queries. Using collections (aka nested tables) that are produced on the fly inside the SQL query or that are returned by …
A small enhancement, but what a golden nugget! At least that’s what I think. 😉 It is now possible in Oracle 12c to export data via a view. I …
Oracle Database 12c ships with a brand new supplied package called UTL_CALL_STACK. This package provides an API for inspecting the PL/SQL Callstack. The package complements the DBMS_ UTILITY.FORMAT_CALL_STACK …
The new Database Express or DB Express database utility is different from the former DB Console. It is based on flash and “built-in” the database. To give you a …
Oracle DB Express is the new replacement for Oracle DB Console in the Oracle 12c database. Here are some first steps to get started. Oracle DB Express makes use …
Is this one of my highlights? No not really, but it is a remarkable one. Oracle XMLDB functionality is now mandatory and can not be uninstalled. As mentioned in …
At long last it’s here: Oracle Database 12cR1. The download of this fresh software package is hardly done. It is time to start sharing some of our early experiences …
Betty van Dongen
June 12, 2013
Continuous Delivery, Development Tools, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, Software Development, Software Engineering, Tools, Web HTML5 CSS3
In this post I would like to share an example how to deploy an .ear file with an Ant script to the Oracle Application Server 10.1.3 (OAS). Automatic deployment …
Last week I was prompted to take a look at the new Oracle ADF Academy that has just published its first lesson: Developing Applications with ADF Mobile. As you …
One of the great features of ADF is the easy out-of-the-box support for Partial Page Rendering (PPR) using the partialTriggers, autoSubmit and partialSubmit properties. And when things get a bit more …
To be useful, data held and used in information systems has to live up to a number of expectations. The data should be an accurate representation of its source. …
Introduction Oracle Designer is a windows client-server development tool that is meant to be manually operated by a developer. Anyone trying to integrate Designer with an automatic build environment …
Lucas Jellema heeft voor Computable zijn ervaringen van de twee weken durende conferentie tour, Yathra 2013, samengebundeld. In het verslag ‘Verkenning van de IT-sector in India’ wordt ingegaan op …
When running a Weblogic server and its managed servers I have heard at multiple projects that there is a need of automatic startup of these server processes. There is …
We all know a lot of money is involved with professional sports. One of Europe’s major sports is football (or soccer as some like to call it). A lot …
This week Oracle released it sixth patchset (11.1.1.7) of the SOA Suite and it’s IDE JDeveloper. In this new release there are some small changes in the IDE, but …
In a recent article (https://technology.amis.nl/2013/04/02/adf-dvt-using-the-tree-map-visualization-component-to-compare-relative-sizes-and-distributions/) I discussed the ADF DVT Treemap component. This component visualizes data in such a way that comparisons between data values for different records and …
Hierbij nog dank voor allen die aanwezig waren bij de weer gevulde, informatieve & gezellige avond tijdens “Hotsos Revisited 2013”. Wij presentatoren hebben genoten van het ambiance. Hier ook …
The tree map component is one of those data visualization components that can tell an entire story through a simple picture. But of course that picture is anything but …
One recurring theme in my articles on ADF has been that end users usually do not care about data. They are interested in getting information that helps them answer …
Communication between taskflows and pages, beans and other components in ADF Faces applications is in many cases ideally implemented using contextual events. These events are published from a producer …
Recently the ADF SIG at AMIS organized an ADF DVT Speed Date. During this speed date six AMIS consultants presented their favorite DVT Component. In a series of blogposts …
Hereby, for those who want another look or for people to share, my presentation content “Creating Structure in Unstructured Data” given during the Hotsos 2013 Symposium on Monday morning. …
One very common pattern in Mobile Apps is the use of “pull” to refresh a list of data in an App. For one of my projects I suggested to …
