Als je dit leest en je bent Oracle professional – ontwikkelaar of administrator – is de kans groot dat je jouw carriere bent gestart in de jaren ‘90, in het tijdperk van Oracle7, Oracle Forms en Client/Server applicaties – net voor de opkomst van Java, internet, mobiel en SOA. Misschien ligt je start daar nog [...]
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 NetBeans http://technology.amis.nl/blog/14709/running-cometd-2-examples-locally-on-tomcat-using-maven-and-netbeans, CometD 2 Java Client Sample – open project in NetBeans based on Maven pom file, modify sources and run Java Based Comet Client (http://technology.amis.nl/blog/14720/cometd-2-java-client-sample-open-project-in-netbeans-based-on-maven-pom-file-modify-sources-and-run-java-based-comet-client) [...]
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 hierarchical queries but also networking or even generic recursive SQL. In Oracle Database 11g, the recursive subquery was formally introduced, the SQL Standard’s approach to this [...]
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 master-record joined with exactly one detail-record. The use case was valid – that was exactly the functionality that was required.
In terms of EMP and DEPT -I [...]
12/12/2011 - 8:35 am
Tags: collection, json, multiset, nested table, oo, pipelined, plsql, table, table function, type, XML, xmltype
Posted in Database, Devel. + PL/SQL tools, XML | 4 comments
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 available to complete the puzzle of structured and modern programming with a touch of OO and more importantly to create a decoupled, reusable API that exposes [...]
1/12/2011 - 9:40 am
Tags: database adapter, Eclipse, jca, oracle service bus, osb, plsql, proxy service, xquery
Posted in Database, Databases, J(2)EE/Java, Java, Java, JEE, OAS and WebLogic Server, Oracle, SOA & Oracle Fusion Middleware | 1 comment
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 description of the implementation of the ESB architecture design pattern – the same that is introduced in the article on OTN – using Oracle Service Bus. [...]
An interesting discussion arose in one of the projects I am involved in. The functional requirement at stake: show records in a table. In one of the columns, show an indicator (checkbox for example) that signals whether or not that particular record has a specific type of details associated with it. You could say that [...]
13/10/2011 - 7:00 am
Tags: 11g, Database, feuerstein, plsql, programming, sql, steven, steven feuerstein, toad
Posted in Announce, Books, Cloud, DBA, Database, Databases, Devel. + PL/SQL tools, General, IT Architecture, Oracle, Oracle Development Tools, Oracle E-Business Suite, SOA & Oracle Fusion Middleware, Software Development, Test, Tools, Unstructured Data | 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 in de wereld heeft verzameld en die hij ook mede door zijn nauwe samenwerking met het PL/SQL product team van Oracle kan verifiëren en aanscherpen. Hij [...]
I just completed my Birds of a Feather session at JavaOne 2011 about Push in an enterprise application architecture. Over 150 attendees were in the audience, many of them asking questions afterwards. It felt like it went well.
The slides for this session are below. I will post source code for the demos at some [...]
3/10/2011 - 7:12 pm
Tags: apex, Database, Java, networking, ODP.net, PHP, sql, sql developer, tom kyte
Posted in Database, Devel. + PL/SQL tools, General, Software Development | No comments
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 the APEX Listener and even the “PL/SQL Gateway” was mentioned. I always have to laugh a bit because this last one touches the XDB Protocol Server [...]
24/9/2008 - 10:28 am
Lucas, thank you for sharing presentation.
There’s a note on p.18 about client_identifier in v$sqlarea. Are you sure it is really there?
24/9/2008 - 12:59 pm
Hi Tim, you are welcome. What I should have said is (from the 11g docu): “Module and action names for a registered application can be retrieved by querying V$SQLAREA or by calling the READ_MODULE procedure [on dbms_application_info]. Client information can be retrieved by querying the V$SESSION view” .