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 …
Category: Languages
Data Integriteit anno 2011 – Hands-on met Toon Koppelaars en RuleGen 3.0 bij AMIS op dinsdag 27 september
![Data Integriteit anno 2011 – Hands-on met Toon Koppelaars en RuleGen 3.0 bij AMIS op dinsdag 27 september]({"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"} "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 …
Generate IDs in all components in ADF Faces pages and fragments – to facilitate automated Selenium based testing
Lately, we have been introducing Selenium based testing for many our ADF Faces based web applications. Or rather, our testers created the tests for the web pages using Selenium. …
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 …
Screen scraping using Google Documents in a minute or less…
In a previous blog Lucas used JSoup to collect data from a web page. In this post I’ll show a declarative way to screen scrape data with the help …
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 …
Running XQuery from Java applications using the XQJ API and the Oracle XDK implementation
While preparing for the new SOA for Java Professionals training program at AMIS, I was recently working on a section discussing XQuery and more specifically the ability to use …
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 …
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, …
How to call a webservice directly from Java (without webservice library)
In this blog I will show you how you can call a webservice programmatically in Java without using a webservice library like JAX-WS or Apache Axis. Normally you would …
Book Review : Oracle ADF Enterprise Application Development – Made Simple
On my way to Los Angeles (Long Beach) for KScope 2011 (12 Hours in an airplane) I had plenty of time to do some reading and writing.The book I …
Turning any XML document into a Java Object graph using JAXB 2.0
As a followup to my recent article on how to Produce and XML document based on data in a POJO structure using JAXB (https://technology.amis.nl/blog/12499/creating-an-xml-document-based-on-my-pojo-domain-model-how-will-jaxb-help-me) I will describe in this …
Creating an XML document based on my POJO domain model – how will JAXB help me?
The challenge is a common one. We have got data in a domain model, based on POJOs. And we need to marshall that data into an XML document. Note …
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 …
Finding the longest streak using SQL Analytical Functions
Some IT organizations that I visit have a sign somewhere indicating the number of days that have passed without a major issue. Production sites with proper respect for health …
Leveraging APEX in XE 11gR2 to rapidly load Excel data into a database table
Whilst preparing for the Thursday Thunder session at the last day of the ODTUG Kaleidoscope 2011 conference in Long Beach, where an all star team of moderators and developers …
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 …
Replace by position
Have you ever wanted to replace a character in a string just by position? I needed this the other day and IMHO there is no way in Oracle PL/SQL …
ADF 11g R2 : Skin Editor First Impressions
June 7, 2011
Development Tools, IT, Oracle, Oracle Application Development Framework, PL/SQL, Web/Java
No Comments
With JDeveloper 11gR2 the skineditor is finally there. I share my first impressions in this post. When you need a skin for your application in previous versions, some configuration …
Oracle XBRL Extention – Second Release now available for Download
The XBRL Extention, a no cost add-on extention on XML-DB targeting the Extensible Business Reporting Language area, is now available for download. This second release ( p12388668_112020_Generic.zip ) of …
Masterclass voor Oracle ontwikkelaars – Lucas Jellema – vrijdag 10 juni – AMIS, Nieuwegein – Advanced Database Application Development
De Oracle Database is in zekere zin ook een Applicatie Server. Of in elk geval is de database een zeer krachtige infrastructuur die door allerlei soorten applicaties kan worden …
XFILES APEX Community Edition (XACE)
Roel Hartman and me are currently very busy with our Kaleidoscope 2011 presentation “XFiles, the APEX Version: The Truth is in There…“. During this presentation, we will demonstrate the …
Getting started with your career (in Dutch)
April 21, 2011
AMIS, Announce / Events, Architecture, Development Tools, IT, Java, Mobile, Oracle, Oracle Application Development Framework, Software Engineering, Web/Java, XML
No Comments
Als bezoeker van deze blog ben je bezig met het maken van mooie oplossingen en nieuwe uitdagingen op technisch gebied. AMIS nodigt je uit om ons team te komen …
How to use an outerjoin to synchronise data
April 11, 2011
AMIS, Database, Databases, PL/SQL, Software Development, Software Engineering
No Comments
There is often a need to synchronize data from a query. For example reading external data and update the tables. Sometimes it can be achieved by a single merge …
Introducing xsd:duration – to define date-time intervals in XML documents (such as OnAlarm duration in BPEL)
The other day a colleague and myself were working on a BPEL process that should wait for a certain period of time for a message to arrive. When the …
DBPITR with a rman archival backup
One of our customers had this request: Can you make a backup of my development database that I can use to restore ( the same database ) to a …
Create an Excel-file with PL/SQL
For this project I took an Apex-plugin I have written, (IR) Report to Excel (xlsx), and turned it into a PL/SQL package. With this package it’s very easy to …
Wat kan je als Forms of database ontwikkelaar met Oracle Database Release 11g?
Een upgrade naar de nieuwste versie van de Oracle Database vindt zelden plaats op initiatief van het applicatie-ontwikkelteam. Upgrades worden meestal gedaan in verband met support-regelingen, op verzoek van …
APEX plugins contributed to the APEX community by AMIS developers
I have to admit that, even though I have tried on several occasions to dive head first into APEX, so far I have only wet my feet. I have …
The Talking Database – on putting query results into words – soundbiting from SQL?
In my investigations into the role the Oracle RDBMS can play in application architectures and especially how Java applications can leverage the database, I have ventured into some strange …