Analyzing Match Scores in ‘fuzzy searches’ – explaining the shades of gray in a non-binary world
In a previous article – Not all has to be black and white in SQL Queries – , I discuss how not all searches are about perfect matches. The …
Category: Languages
OOW 2008 Preview: ADF 11g and APEX – Same themes, different challenges
September 15, 2008
Development Tools, Oracle, Oracle Application Development Framework, PL/SQL, Web/Java
No Comments
Last Thursday nine OOW presenters rehearsed their presentations for Oracle Open World 2008. As I won’t be in San Francisco next week, I was very glad with the opportunity …
Running a BPEL process created with Netbeans in Apache ODE
A BPEL process without using vendor specific extensions should run everywhere without much hassle. But unfortunately it doesn’t. In this article I will show you how to create a …
Database upgrade apex.oracle.com
Oracle has upgraded the apex.oracle.com service. Now you can use this free service to evaluate Oracle Application Express and (some of) the new PL/SQL and SQL features of the Oracle …
Referential Integrity with Virtual Columns, the Sequel
![Referential Integrity with Virtual Columns, the Sequel]({"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"} "Referential Integrity with Virtual Columns, the Sequel")
The comments on the blogpost on Referential Integrity with Virtual Columns lead to this entry. As a recap: In the above mentioned blog post I showed how you can …
Referential Integrity with Virtual Columns
During ODTUG, a couple of weeks ago, Tom Kyte did a presentation on the “Top 10 11 things about Oracle 11gR1″. The presentation can be downloaded from asktom.oracle.com. He …
Juggling with SQL Types in SQL and PL/SQL – fading borders between Collection and Table
While preparing for a whole different topic, I had to create a few demonstrations of using custom SQL Types and Collections in both SQL and PL/SQL. While nothing spectacular …
Instrumentation
During the ODTUG conference in New Orleans, there were multiple sessions for the Development/DBA. As I consider myself a developer with a great interest in the database, I love …
Quering RSS Feeds The XMLDB Way
Actually this is old stuff (2006), but it got lost in a comment section. I think this can still be useful to some and I also post this here …
Integrating Flashback in ADF Web Applications – providing the historic perspective
June 20, 2008
Database, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, PL/SQL
No Comments
When we were doing the APEX vs. ADF session at the last day of the ODTUG Conference yesterday, Dimitri showed a nice feature in APEX that allows you to …
Rapid PL/SQL Web Service Client development (using soapUI and utl_http)
I have written about similar topics on several occasions. But now I feel an urgent need to do so again. As with the use of the wonderful soapUI tool …
Father’s day at ODTUG Kaleidoscope 2008
Together with Aino Andriessen, Alex Nuijten, Lucas Jellema I travelled to New Orleans to attend the ODTUG Kaleidoscope Conference 2008. Today, the ODTUG is starting full speed, no time …
Accepted AMIS Oracle Open World Presentations
June 5, 2008
AMIS, Databases, DBA Oracle, IT, Java, Oracle, Oracle Application Development Framework, Software Engineering, XML
3 Comments
Today me colleagues Lucas, Gerwin and I got some nice “Oracle Open World Welcome Notification” e-mails from the Oracle Open World 2008 team. We are happy to announce that …
Testing Rulegen using Codetester
When I was presented with the possibilities of Rulegen it made me wonder: How can these rules be tested. Rulegen is a tool to create rules in the database …
DBA Conference Holland & XMLDB Whitepaper
Given by Dutch DBA’s for DBA’s: The DBA Conference in Holland next week, the 27th of May 2008, Zeist. Oracle DBA Symposium Yours truly will also present as you …
JDeveloper 11g Technology Preview 4 available – (JIT for JavaOne)
The Oracle Technology Network just published the fourth Technology Preview for JDeveloper 11g. In the nick of time to demonstrate and announce for JavaOne 2008, that starts in a …
Using SoapUI on Apache ODE to test your BPEL processes more quickly
On the SOA-training I’m following we’re using the Oracle SOA Suite, a very nice product, but the time needed between saving changes and deploying the process takes way too …
RuleGen – the next generation framework for Data Logic (aka Data oriented business rules)?!
RuleGen is a framework that aids in implementing data integrity rules inside the Oracle RDBMS. That’s what it says on the website – www.rulegen.com – and that was the …
11g Technology Preview: XML Data Retrieval via Equi Partitioning by Reference
The success or downfall of your application is determined by proper logical and physical design, especially if it is based on stored XML data in an Oracle database. The …
Oracle announces XQuilla / XQilla XQuery engine available under the open source Apache 2.0 license
In the year that XML celebrates his 10th anniversary, Oracle announces to make the XQuilla XQuery engine available under the open source Apache 2.0 license. Via official sources, the …
My SOA architecture and webservices mindset…
At AMIS they are working on teaching a lot of us about the fundamentals of SOA. We just had the first couple of events in which Lucas and Peter …
Oracle DBA Symposium in Holland
Planboard organiseert een Oracle DBA Symposium op dinsdag 27 mei 2008. In tien technische sessies, verdeeld over twee parallelle tracks, delen DBA’ers hun praktijkervaringen met de deelnemers. Ze laten …
HOTSOS 2K8 – What Does Inspire Us…?
I can tell you about the next day. But I won’t. Most of it is (for people with the same interest) a known fact anyway. There was Tapio’s presentation, …
The Pro Active Database – Advanced Application Development with the Oracle Database
One of the themes of the seminar I am presenting next Tuesday – during the Red Database Symposium in The Hague – will be ‘the pro active database’. Of …
Advanced Application Development with the Oracle Database – preparing for the RedDatabase Symposium (11th March 2008, Den Haag)
I am having fun today. Today I started in earnest with my preparation for the RedDatabase Symposium, a very promising three-day event on the Oracle Database, with a total …
Saving (XML) data directly to disk
I was asked, also after the former post “Selecting (XML) data directly from disk“, what the best way would be to save data directly (locally) to disk via XMLDB …
Selecting (XML) data directly from disk
On the OTN XMLDB Forum, a question was asked if you could directly select from a XML file on disk, or to be more precise ” XQUERY / XMLTABLE …
Puzzelen met SQL: Crash SQL Investigation
door Anton Scheffer en Alex Nuijten Dit artikel is de on-line tegenhanger van de rubriek Puzzelen met SQL die verschijnt in de Optimize, het vakblad voor Oracle ontwikkelaars in …
UKOUG 2007 – The Final Verdict of the Attendees
Today, I got my evaluation results for my presentation during UKOUG last year. Overall, I am not unhappy. I am a little bit perfectionist minded, but for a first …
APEX and/or ADF – demonstrating two similar yet different applications – part 2
December 24, 2007
IT, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, PL/SQL, Web HTML5 CSS3
4 Comments
Showing both APEX and ADF and giving the audience some inkling as to there similarities and their differences – what is the best way of doing that? Well, one …
APEX and/or ADF – demonstrating two similar yet different applications
December 23, 2007
Database, IT, Java, Oracle, Oracle Application Development Framework, PL/SQL
8 Comments
Last Monday, we organized an AMIS Query on APEX and ADF. Dimitri Gielis, APEX specialist, joined us and presented his ideas on APEX. I took on the role as …
Where is my WHERE?
Sometimes I encounter query which have a WHERE clause that starts with: select ... from ... where 1=1 and ... When asked the reason for this predicate, most of …
UKOUG – Pictures and some not so nice stuff…
Thanks to Daniel Fink I was able to upload some pictures now. Have a look at my written posts. In the meanwhile (if you didn’t notice) a not so …
UKOUG – Running the Gauntlet
I didn’t "do" much on Tuesday regarding the attending of sessions. I saw Alex Gorbachevs’s presentation regarding "RAC connection management". I was a little bit "afraid" of the "RAC" …
Puzzelen met SQL – de Kassabon
Dit artikel is de on-line tegenhanger van de rubriek Puzzelen met SQL die verschijnt in de Optimize, het vakblad voor Oracle ontwikkelaars in Nederland. Vooral op het …
UKOUG – Monday First Impressions and The Human Lottery Show
On Sunday I left to Birmingham to attend and, for the first time, speak at the UKOUG. It started off completely wrong. I went with a taxi to the …
Custom authentication in Apex (part 1)
Another word for authentication is acces control. Authentication is the mechanism to verify the user’s identity and provide access to a system or application based on the credentials entered …
and now we present… 11g and Apex on Ubuntu
Thanks to a completed messed-up Windows (I managed to demolish my network connections beyond repair) and a helpful tutorial from Dizwell’s blog (thank you oh so very much!) I …
AMIS Query – on developing Web Applications with Oracle development technology: ADF and Application Express side by side (with Dimitri Gielis and Lucas Jellema)
AMIS is proud to announce an AMIS Query on Monday 17th December 2007: Developing Web Applications with Oracle development technology: ADF and Application Express, side by side. There are …
KC "Kennismaken met Application Express" – Presentation available for download
On Thursday the 22nd of November 2007 Patrick Sinke and I did a presentation and a small workshop about Oracle Application Express. We gave an introduction of this Oracle …