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 laat via code-voorbeelden en interactieve sessies zien hoe je als ontwikkelaar in staat bent om snel, hoogwaardige, goed onderhoudbare en uitbreidbare applicaties kunt maken.
Er is tijdens dit seminar voldoende ruimte om vragen te stellen en ideeÃ«n met Steven Feurestein uit te wisselen.
Bij dit seminar zijn de volgende zaken inbegrepen:
- Een exemplaar van het boek Oracle PL/SQL Programming (5th edition) van Steven Feuerstein (twv â‚¬71,-).
- Een PL/SQL quiz onder leiding van Steven Feuerstein met leuke prijzen.
- Ook ontvang je een gratis jaarabonnement op het PL/SQL Channel. Hiermee heb je toegang tot 27 uur videotraining (normaal $395).
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 which can do way more then only this PL/SQL extension for APEX which has been embedded in this XDB Protocol Server framework. There is a APEX book out there that touches a bit the possibilities of the framework, one of the reasons I will promote and explain it a bit more during conferences like UKOUG, because I think its a shame that people don’t know its full potential. Anyway. Tom stressed once again that APEX is a serious environment regarding the huge websites out there based on APEX supporting 1000th of user sessions. Also it nowadays had a better debug support (4.1) and use / support for ROWID, improved data upload and calendar wizard support and redesigned websheets in APEX 4.1.
After reading the title of this blog post, you could easily be forgiven for not having a clue what this piece of writing will be about. Not to worry, soon, this will all change.
A warning is due, however. Being called the AMIS Technology blog, this place is usually (over)filled with code, code and then some more code. Not this time. Stop reading here, if you are looking for code.
This short article will be about the most overlooked part of software development. And I am not even talking about testing or documentation. No, there is another aspect to software development that seems to be neglected on an even larger scale.
Hereâ€™s a short update for those who, just as I did, searched for hours to the solution of getting an outcome object instead of the standard outcome string of a Human Task. You need to know this one detail if you want to get the object as an outcome. And at the end it makes sense, as almost everything does if you know what to do .
Here it goes…
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 from some external source. Well actually, from several external sources. The loading of the data is done in a better safe than sorry way: it is very important that all records come in. At the risk of loading duplicates – we will get them all!
However, once they are all in, there are more in than we want: I have loaded quite a few duplicate records. That will hurt the later on, so the duplicates have to go. With Oracle SQL Analytical Functions, that is quite easy. In two steps:
1) identify the duplicates
2) remove the duplicates
Tour de France 2011 – Analysis using ADF DVT Graphs – Part 2 – Gap with Cadel for Top 5 throughout the stages1
This article uses the statistics about this year’s Tour de France to visualize the gap between each of the top 5 riders and Cadel Evans – throughout the 21 stages. It produces a line chart that provides easy insight in the history of this year’s event – making it abundantly clear that for example Contador never really stood a chance and only kept losing time. It also shows that Frank Schleck did very well indeed, outpacing is brother for the first 17 stages.
The chart this is created in this article looks like this:
It is fairly basic – created using only simple declarative ADF DVT settings. The greatest hurdle to overcome was the creation of a SQL Query that returns the required data in format that is easily consumed and processed by the graph.