Category: PL/SQL
The Java Specification Request 317 (JSR-317) aka JavaTM Persistence 2.0, (JPA 2.0) has finally reached the last stage, “Completion of Reference Implementation (RI) and Technology Compatibility Kit (TCK)”, before …
Every year ODTUG – Oracle Development Tool User Group – organizes a conference, called Kaleidoscope. This time it was in Monterey, California. If you have never been to …
Last week, this weblog hit the 9M post reads mark. Since we started technology.amis.nl/blog in July 2004, it took us some 5 years to get to that point. …
During the years I have a lot of times encountered performance problems that ended up to be fast queries (less than 10ms) which are executed very much. In these …
Lucas already gave a very good in depth overview of the "Hotsos Revisited" session last night. It always amazes me how fast he can make a cool blog post …
It’s Monday night and a select company of DBAs and Database developers have gathered at AMIS HQ in Nieuwegein for the ‘Looking Back at Hotsos 2009’ session. It …
Today I was triggered by a question on the JDeveloper forum about invoking a popup from a backing bean. Actually some time ago I had to build that solution …
Say, you are in need of a directory listing from within the Oracle database similar to the one generated with Unix command ls. Your database doesn’t contain a JVM, …
April is the month of the presentations and seminars for me (May and June too by the way). On Wednesday April 22nd, I will be presenting a seminar …
Another world shattering topic: analyzing tag clouds. This article describes a very simple first step for some analysis at database level of tags that have been associated with database …
When developing an application it makes sense to add logging to this application. The Apache Commons Logging is a way to implement logging to your application independent of the …
Many people have tried to unwrap wrapped PL/SQL. Most people haven’t succeeded in doing it, but since Pete Finnegan’s presentation on the 2006 Black Hat conference, http://www.blackhat.com/presentations/bh-usa-06/BH-US-06-Finnigan.pdf, unwrapping …
A quick overview of you can create an SCA Composite Application that publishes a WebService interface, accepts SOAP Messages and write their contents to a file, appending a …
An Application Context in the Oracle Database is a name in-memory collection of key-value pairs. Applications can store values in an Application Context – using a package associated with …
Aanstaande dinsdag 20 januari 2009 van 16:30 tot 20:30 ben je van harte uitgenodigd bij de PL/SQL Potpourri. Een kennissessie waarbij acht AMIS-consultants in negen korte presentaties iets zullen …
In this blog I will show you how easy it is to build a process with Oracle Workflow. This demo consist of an automatic step (plsql function) and …
During the 7Up workshop, a workshop geared towards experienced developers who want to get up to speed with everything that happened in Oracle since release 7, one of the …
Steven Feuerstein wrote an entry on his Toadworld blog where he checks the refactoring capabilities of SQL-Developer. I am trying the same things in PL/SQL Developer to see if …
One thing that always draws me in tools, libraries and frameworks: what are the hooks, the backdoors, the extension points, the APIs, the event listener registration facilities etc. Today …
For the last two days the AMIS 7Up Workshop took place in our office in Nieuwegein. The training consists of two SQL and another two days of PL/SQL. During the first …
My challenge of the day: a query that returns aggregate values. And that can be manipulated dynamically to sometimes aggregate grouped by one dimension, sometimes along multiple or …
The Flow activity is used to configure parallel activity in BPEL processes. In theory, activities contained in two or more branches (sequence containers) inside a Flow activity are …
Yesterday evening we had a nice, interactive, session about PL/SQL Developer. Theo Tol (BI4U) came by to tell us more about the tool and how it can be used. …
One of the intriguing subjects at last weeks Oracle Open World conference for me was Complex Event Processing. The ability to process streams of real time events, and up …
Last night, the AMIS crew that visited the Oracle Open World conference reported their findings in a 3.5 hour session. In segments on SOA & BPM, Middleware, Database, Oracle …
Maybe the following question will arise after reading the title: Oracle Workflow isn’t that obsolete technology? The answer can be very short: Yes it is. (Read the SOD on …
In het midden van de 90-er jaren waren er heel weinig en vrij beperkte ontwikkeltools beschikbaar voor het ontwikkelen van PL/SQL. Tegenwoordig is dat heel anders en zijn er …
I just completed my second presentation here at Oracle Open World. It discusses Application Development inside and with the Database, introducing and discussing quite a few trends, concepts, best …
Recently I was working on an RSS feed aggregator – a SQL Merge statement that through the use of httpuritype and XMLTable scans multiple RSS feeds and merges the …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
![My ODTUG Kaleidoscope 2009]({"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"} "My ODTUG Kaleidoscope 2009")