Category: PL/SQL
This presentation will hopefully convince database developers that types in the Oracle Database are worth their salt – and more. With the recent improvements in 11gR2, the pieces are …
Now that the UKOUG annual conference in Birmingham is over, it’s time to write my thoughts down. As this was the second time that I attended the UKOUG conference, …
Slides for the presentation I did with Grant Ronald during UKOUG 2011, last week in Birmingham. The abstract for this presentation: “Many organizations run enterprise Oracle Forms applications created …
When you create a “Report with Form”, there will be an icon in the report which allows you to navigate to  the form page. Only when the user clicks …
A few weeks ago I had to work with a virtual box by oracle with a pre installed Database (xe) and weblogic to do some BPM Studio work. After …
While working on the challenge to publish a message to a JMS Queue in a remote WebLogic Server from within the Oracle Database – using a Java Stored Procedure …
Robbrecht van Amerongen October 13, 2011 Announce / Events, Architecture, Big Data, Book reviews and Publications, Cloud, Database, Databases, DBA Oracle, Development Tools, IT, Oracle, Oracle E-Business Suite, PL/SQL, SOA, Software Development, Testing, Tools In dit tweedaagse seminar neemt Steven Feuerstein je mee ver voorbij de basismogelijkheden van PL/SQL. Steven zal tijdens dit seminar de best practices behandelen die hij op tientallen plekken …
Aanstaande vrijdag geef ik voor de derde keer de Masterclass Advanced Oracle SQL. Deze MC gaat over SQL – dat zal duidelijk zijn. We gaan de mogelijkheden van SQL …
Afgelopen dinsdag 4 oktober waren Andre van Winssen en ik de aangewezen personen om een presentatie bij de OGh te verzorgen. Andre vertelde in ongeveer een uur het een …
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 …
Currently at Tom Kyte’s session regarding topics new, improved or coming in Oracle Application Development. Tom told about the history APEX has gone thru and the current setup with …
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 …
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 …
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 …
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 …
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 …
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, …
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 …
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 …
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 …
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 …
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 …