Category: Languages
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 …
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 …
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. …
Alex Nuijten September 8, 2011 AMIS, Announce / Events, Database, IT, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, PL/SQL, SOA, WebCenter 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 …
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> …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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, …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
Alex Nuijten June 14, 2011 Announce / Events, Database, DBA Oracle, Development Tools, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, PL/SQL, SOA, Software Engineering, Web/Java, XML 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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
Robbrecht van Amerongen April 21, 2011 AMIS, Announce / Events, Architecture, Development Tools, IT, Java, Mobile, Oracle, Oracle Application Development Framework, Software Engineering, Web/Java, XML 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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …