Being a San Francisco "local celebrity"
This week, I went on an invitation of my publisher Packt to Oracle OpenWorld, to be present on the launching of my book, Oracle WebLogic 11gR1 PS2: Administration Essentials. …
Category: Oracle
ADF 11g Rich Faces: using popup for viewing and editing big fields
During the Oracle Open World conference going on this week I was asked by one of the attendees to one of my sessions for a little guidance on the …
Oracle Open World 2011: Oracle Database 11g Features for Developers by Connor McDonald
![Oracle Open World 2011: Oracle Database 11g Features for Developers by Connor McDonald]({"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"http:\/\/seattletimes.nwsource.com\/ABPub\/2012\/08\/02\/2018836700.jpg","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"} "Oracle Open World 2011: Oracle Database 11g Features for Developers by Connor McDonald")
Yesterday I had the pleasure of attending a session by Connor McDonald. I heard a lot about him, his presentation style, and I even did a book review back …
ADF Gold Nuggets – from Oracle Open World's ADF Enterprise Methodology Group Super Sunday
Sunday 2nd of October 2011 saw, in the prelude to the Oracle Open World conference, the ADF Enterprise Methodology Group’s Super Sunday. Six valuable presentations on planning, designing, building …
OOW 2011 – NoSQL Databases and Oracle Database Environments
I am currently at a presentation of Patrick Schwanke, Quest Germany, regarding easy and high speed connect between NoSQL and Oracle Databases. Not really what I planned but as …
Oracle Open World 2011; Unstructured Data and Multimedia SIG
Oracle Open World is underway. My first session, which I didn’t plan, was on Unstructured Data. There is a lot of unstructured data going around, as opposed to relational …
OOW 2011 – and SOA: It's everywhere you look…
Do you see what I see – or am I imagining things?
Where am I, and what am I doing… Oracle Open World 2011
This post is more for me than it is for you, at least I will have a place to quickly check where am I supposed to be going next.The …
My Agenda for Oracle Open World 2011
As the conference draws awfully close, I am trying to compose my final agenda. Some anchorpoints are my own sessions – those I have to attend. Then there is …
WebLogic 11g start and stop automation
There are many ways of starting and stopping your Oracle WebLogic 11g  environments, You can stop your Admin and Managed Server Instances through the Adminsitration console, use the the …
Oracle XMLDB XQuery Update in Database Release 11.2.0.3.0
I just made use of the very cool OTN Virtual Developer Day Database site. In this environment you can follow OTN Developer Day sessions, for example, at home, while …
Data Integriteit anno 2011 – Hands-on met Toon Koppelaars en RuleGen 3.0 bij AMIS op dinsdag 27 september
datum: dinsdag 27 september; 16.30 uur locatie: AMIS, Edisonbaan 15, Nieuwegein sprekers: Toon Koppelaars en Lucas Jellema Het belang van data integriteit behoeft geen toelichting – als het goed …
Oracle Database Appliance – mid market pre-engineered, pre-integrated, one-stop in a scalable (license) model
Oracle just announced the Database Appliance – something perhaps best described as a Exadata’s dumb little brother – a pre-integrated, optimized piece of hardware for running Oracle Database. The …
Oracle Open World / Java One Preview bij AMIS
September 8, 2011
AMIS, Announce / Events, Database, IT, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, PL/SQL, SOA, WebCenter
No Comments
Op maandag 19 september zal er bij AMIS een Oracle Open World Preview sessie worden gehouden. Een groot deel van de Nederlanders die het dit jaar gelukt is om …
Business Rule: Only One per Day, but keep the time
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) SQL> …
Implementation of a moderately complex data constraint business rule using RuleGen 3.0
In a previous article, I have introduced RuleGen 3.0 – a 2nd generation business rule implementation framework for the Oracle Database: https://technology.amis.nl/blog/?p=12807. RuleGen provides a solid, structured, scalable framework …
FatWire integrated into WebCenter as WebCenter Sites for Web Experience Management
The recently announced acquisition of FatWire by Oracle is leading to interesting new options for customers looking for dynamic, interactive, multi-channel & device end user facing web sites – …
Clone your Oracle FMW SOA Suite 11g
Sometimes, you would like to have an extract from a SOA Suite 11g  production environment to test it in a test or acceptance environment. There are several ways to …
ADF DVT Hierarchy Viewer on demand – made to order multi table hierachy view
This morning, I noticed the following email sitting in my Inbox: “Hello, Lucas. I found Hierarchy Viewer demo from https://technology.amis.nl/blog/5786/adf-11gr1-new-hierarchical-viewer-for-visually-pleasing-representation-of-data-structures. But i need to implement some kind of solution. …
Shortly to follow – a book review – Oracle WebCenter 11g PS3 Administration Cookbook by Yannick Ongena (Packt Publishing, 2011)
August 5, 2011
Oracle, Oracle Application Development Framework, Oracle WebLogic Server, SOA, WebCenter
No Comments
Hot off the press (well, that is what you always will have with printing on demand I suppose) I received an electronic copy (not off the press after all) …
Remove duplicate rows with Oracle SQL ROW_NUMBER – intelligent and efficient data cleansing
I am quite sure I have addressed this before. But I could not find it readily and I needed it today. So here it goes: I am loading data …
ADF 11g : Show PDF in a Popup
In one of my previous posts I showed how to use ADF popup components to display external content such as webpages like wikipedia in an inline frame. Based on …
Tour de France 2011 – Analysis using ADF DVT Graphs – Part 4 – Spark Charts
July 27, 2011
Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server
No Comments
The final episode in a series on ADF DVT applied to the Tour de France 2011 results. In this series, I have used many of the ADF DVT Graph …
Tour de France 2011 – Analysis using ADF DVT Graphs – Part 3 – Distance, Speed and Withdrawals with Pareto, Combination, Stock Chart (High/Low) and Bubble Chart
Another article on analyzing and visualizing the results from the Tour de France 2011 using the ADF DVT components. This article uses the same set of data already discussed …
Tour de France 2011 – Analysis using ADF DVT Graphs – Part 2 – Gap with Cadel for Top 5 throughout the stages
This article uses the statistics about this year’s Tour de France to visualize the gap between each of the top 5 riders and Cadel Evans – throughout the 21 …
Update day to second interval column in selection from time gaps table by parsing strings containing time differences using REGEXP_SUBSTR
An apparently trivial challenge that still took me bit longer than expected. What is the situation: I have a table with two columns (of interest). One is a column …
Tour de France – Analysis using ADF DVT Graphs
In two previous articles, I have explained how it is possible to get hold of the results of the Tour de France 2011 (and previous years) using simple Java …
Book review: JDeveloper 11g Handbook: A Guide to Fusion Web Development
In this blog I will share with you my experiences with the Oracle JDeveloper11g Handbook – A Guide to Oracle Fusion Web Development (McGraw-Hill, 2010) – written by Duncan …
Oracle Scheduler, the things you ought to know
At the KScope conference in Long Beach, CA one of the most interesting sessions I attended was a session called: Five Features You Ought to Know About the Oracle …
ODTUG KScope 2011
Last week I attended my very first ODTUG KScope conference in Long Beach, California. I have attended conferences by ODTUG before, but they were never this broad. Sunday On …
ODTUG KScope 2011: looking back
Last week the yearly ODTUG KScope conference took place in Long Beach, California. I always need to time to let this wonderful event really sink in. The number of …
RuleGen 3.0 – the latest, leanest and most robust solution for complex data constraints in an Oracle Database
No matter how complex the enterprise and application architectures become, no matter the number of tiers, services, devices and user interfaces – at the heart of most enterprises will …
Using SQL UNPIVOT to prepare data for dynamic ADF Faces User Interfaces
The UNPIVOT operator was introduced in Oracle Database 11g – see for example: https://technology.amis.nl/blog/2421/the-oracle-11g-unpivot-operator-turning-columns-into-rows. In Oracle, the UNPIVOT operation is the process of turning Columns to Rows. Put simply, …
Using the ADF DVT Radar Graph for comparing series – further analyzing ODTUG Kaleidoscope 2011 Session Schedule
June 22, 2011
Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server
No Comments
I have always had a fascination for the Data Visualization capabilities of all the tools and technologies I have worked with. For example: I worked with Oracle Graphics 2.0, …
Choosing the best way for SOA Suite and Oracle Service Bus to interact with the Oracle Database
In the past few weeks, I have encountered a similar discussion in various organisations. Each organisation uses either SOA Suite (11g) or Oracle Service Bus (11g) at the core …
Tracking the moving history of averages and other aggregates – Flashback Aggregates in Oracle SQL
You may have seen we write on Flashback functionality in the Oracle Database. It’s an area that I like – especially since the introduction of the Flashback Data Archive …
Creating JSON document straight from SQL query – using LISTAGG and With Clause
This very brief article demonstrates how a fairly complex, nested JSON document can be created using a single SQL query. The main features used in the SQL statement are …
ODTUG KScope Preview 2011
Ook dit jaar, namelijk op dinsdag 14 Juni, organiseert AMIS de ODTUG Preview. Het jaarlijkse congres van de ODTUG, de Oracle Development Tools Users Group, vind dit jaar plaats …
Producing simple Pie Chart straight out of the Oracle Database – leveraging dbms_epg, CANVAS, LISTAGG and some JavaScript
Once upon a time, I had something of a reputation for creating Charts in SQL. Bar Charts, Pie Charts, Gantt Charts and several other unlikely chart types, all created …
Browser-based log-monitor for database applications (alternative to dbms_output,leveraging pipe and Embedded PL/SQL Gateway with a touch of AJAX)
One of the topics I discussed in today’s Masterclass Advanced Database Development was inter-session communication – or how database sessions can exchange information. One of my favorite vehicles to …