Oracle SOA Suite 11g & WebLogic 11g: automatic start after reboot
In an previous post I discussed the stop start automated mechanism already, but now I developed a procedure how to automatically startup a complete Oracle SOA Suite 11g after …
Category: Database
Oracle XML Training With Marco Gralike
I was asked by Jože Senegačnik, if I would be would be interested in doing a Masterclass/Seminar in Slovenia and, yes of course, I really liked the idea. So …
Masterclass Oracle 11g voor Database Ontwikkelaars – haal meer uit SQL en PL/SQL in 11g
![Masterclass Oracle 11g voor Database Ontwikkelaars – haal meer uit SQL en PL/SQL in 11g]({"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"} "Masterclass Oracle 11g voor Database Ontwikkelaars – haal meer uit SQL en PL/SQL in 11g")
Aanstaande vrijdag 27 januari verzorgt Oracle ACE Director Alex Nuijten bij AMIS Services in Nieuwegein een Masterclass voor Oracle Database Developers: iedereen die met enige regelmaat SQL en/of PL/SQL …
Publishing to CometD Bayeux Channel from inside the Oracle Database – PL/SQL based push to CometD Web Client
In recent articles, I have introduced CometD as framework for Server to Client and Client to Client Push: Running CometD 2 examples – locally on Tomcat using Maven and …
Using the Oracle XMLDB Repository to Automatically Shred Windows Office Documents (Part 1)
December 20, 2011
AMIS, Architecture, Big Data, Database, DBA Oracle, Oracle, PL/SQL, XML
7 Comments
People who have attended the UKOUG presentation this year where Mark Drake, Sr. Product Manager XML Technologies / XMLDB, Oracle HQ, and I demonstrated the first principles of the …
Factorial in Oracle SQL – using both new Recursive Subquery and classic Connect By approach
I regularly teach a masterclass on Oracle SQL. One of the topics I explore in depth is the use of the CONNECT BY query style to perform not just …
Weird ADF 11g requirement addressed with left outer join and modern SQL join syntax
The functional requirement was a little unusual. The page should either show all master-records or – depending on the value of a parameter – it should show exactly one …
UKOUG 2011 – Drag, Drop and other Stuff. Using your Database as a File Server
Last Thuesday, Mark Drake, Senior Product Manager and I, delivered a good presentation during UKOUG in Birmingham about how to use your database, via XMLDB functionality, as a file …
Absolutely Typical – The whole story on Types and how they power PL/SQL Interoperability (UKOUG, 2011)
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 …
Looking back at UKOUG 2011
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, …
Implementing Web Services backed by a Database PL/SQL API using the Oracle Service Bus
This article accompanies an article on the Architecture section of Oracle Technology Network (OTN): Implementing the Enterprise Service Bus Pattern to Expose Database Backed Services. It provides a detailed …
APEX: Make a report row clickable
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 …
UKOUG 2011: Using your Database as a Fileserver
UKOUG 2011 is nearby and one of the coolest things in Oracle 11g and onwards is, IMHO, a functionality called XDB Repository Events. Most of you probably know that …
Review: The Method-R Profiler
I was lucky enough to get my hands on the Method-R Profiler and had a test drive with it. So first of all what is it? As you might …
Some explorations around Java Stored Procedures in the Oracle Database
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 …
Rman 11gR2 changes tag labeling of the inc backup in incrementally updated backups
In (rman) incrementally updated backups, only incremental backups are done after the first full backup to the Fast Recovery Area. From 11gR2 on the incremental backup pieces will get …
How to switch datafiles to FRA and back again
If you, like me, like to use (rman) incrementally updated backups, a copy of all datafiles will be present in the Fast Recovery Area. That becomes quite handy if …
2 dagen seminar door Steven Feuerstein: Best of Oracle PL/SQL (8 en 9 december)
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
No Comments
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 …
Masterclass Advanced Oracle SQL – vrijdag 14 oktober 2011
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 …
Report from Oracle Open World – op maandag 17 oktober, 17.00 uur bij AMIS in Nieuwegein
October 11, 2011
AMIS, Data Warehousing & BI, Database, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, SOA, Web HTML5 CSS3
No Comments
Het zal je niet zijn ontgaan dat vorige week in San Francisco Oracle Open World woedde. In een krappe week legde Oracle voor zo’n 45.000 bezoekers de strategie neer, …
OGh bijeenkomst 4 oktober
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 …
OOW 2011 – Oracle XMLDB and Big Data
Last day of Oracle Open World and I am currently attending the last presentations. The first presentation, “Oracle XMLDB: A noSQL Approach to Managing all your Unstructured Data”, deals …
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 …
OOW 2011 – What's New, Improved and Coming in Oracle Application Development
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 …
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 …
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 …
OOW 2011 – On Our Way
Early mornings…really hate them, but can avoid it this time due to our flight going out towards San Francisco is scheduled at 9.50PM. Oracle Open World is near and …
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 …
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 …
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 …
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 …
AMIS Mobile SIG – rain sensors pouring data into the mobile network
July 5, 2011
Database, Mobile, Oracle WebLogic Server, Software Development, Web HTML5 CSS3
No Comments
Last night, the AMIS Mobile Special Interest Group convened. This session had as objective to explore the many different mobile agents and devices that we encounter, the types of …