AMIS, Data Driven Blog – Oracle & Microsoft Azure
Getting value from IoT, Integration and Data Analytics
At long last it’s here: Oracle Database 12cR1. The download of this fresh software package is hardly done. It is time to start sharing some of our early experiences with this major milestone in the history of Oracle’s flagship product. The importance of the 12c release lies not necessarily on […]
0 
0 When you write a lot of code, no matter what sophisticated framework you use, there are pieces of code that you end up writing over and over again (especially when using Java). Writing logging code in Java is a good example. A common pattern is to initialize a static logger […]
0 0 Hereby, for those who want another look or for people to share, my presentation content “Creating Structure in Unstructured Data” given during the Hotsos 2013 Symposium on Monday morning. HTH Marco Hotsos 2013 – Creating Structure in Unstructured Data from Marco Gralike
0 0 I use subquery factoring a lot, to make my SQL queries easier to write. This basically means that most of my queries these days start with WITH rather than SELECT. (this feature was introduced in the 9i release of the Oracle Database). Today I was wondering whether I can also […]
0 0 While working on a Web application that required some page to report data aggregated on several levels of time period – by month, quarter or year – I ran into a very handy way to use the TRUNC function. I was not aware of this usage until now – and […]
0 0 Van 3 tot en met 7 maart vindt in Irving, Texas, het internationale Oracle performance Hotsos Symposium plaats. Dit jaar belooft het symposium een garantstelling voor inhoudelijk hoogstaande presentaties en discussies, want naast presentaties van Tom Kyte, Cary Millsap, Maria Colgan en Steven Feuerstein over performance, worden er ook onderwerpen […]
0 0 The Oracle ACE directors and Java champions are organizing an evangelist event called ‘OTNYathra 2013’ between 15th & 27th February 2013. The event is sponsored by the Oracle Technology Network. I will be one of the speakers on this tour – presenting two or three presentations at each of the […]
0 0 Vorig jaar heb ik behoorlijk wat vragen gekregen over of er een tool was, een methodiek, om BAG data van het Nederlandse Kadaster in een Oracle database te krijgen voor allerlei doeleinden. Basisregistraties Adressen en Gebouwen (BAG) data wordt onder andere uitgeleverd door het Kadaster in XML bestanden waarin alle […]
0 0 At the OTN SQL and PLSQL forum I promised to publish some code I use for a project I’ still working on. This code allows you to select the content from an Excel document
0 0 RAC and single instance RMAN backup is similar, but… Backup of a 11gR2 RAC database is similar to that of a single instance 11gR2 database. There is an important difference though… assuming that you – like me – schedule a non-RAC backup by cron on the database node, using local […]
0 0 In a recent article – Advanced SQL to find valid periods – juggling with outer joins, running totals and analytical functions – I discussed how to use Analytical Functions in SQL to cleverly (!) derive the valid periods from a database table that contains periods of inclusion and exclusion. A […]
0 0 After teaching the Advanced SQL Masterclass recently, one of the attendees confronted me with an interesting challenge for me to solve with all the tools I had been discussing all day. This challenge originates in the world of insurance and revolves around policies. Apparently (I am not much of an […]
0 0 Als sluitstuk van de jaarlijkse Oracle OpenWorld conferentie brengt AMIS een whitepaper uit. Een handzaam document waarin het volledige verhaal van Oracle OpenWorld 2012 is gebundeld. Een team van AMIS was tijdens de conferentie in oktober nadrukkelijk aanwezig; als sponsor, deelnemer, netwerker en spreker – en als aandachtig luisteraar en […]
0 0 Oracle APEX Best Practices explains how to build robust and secure APEX applications. The authors have a proven track record in the Oracle APEX world. The intended audience of this book is a developer with some APEX experience. Oracle APEX Best Practices is not the beginners guide into APEX. But after you have made your first steps in APEX development, you should definitely take a look at this book.
0 0 I have just completed my first ever presentation on the Expertezed.com network – http://www.expertezed.com/ , a reprise from my session on Oracle OpenWorld 2012. This presentation includes a number of slides regarding 12c features, based on the session and slides from Tom Kyte (Top 12 new features) and my notes […]
0 0 Of je nu ‘klassieke’ Oracle applicaties ontwikkelt, met APEX bezig bent, een SOA landschap inricht of een Java/JEE (bijvoorbeeld ADF) applicatie bouwt: het fundament van veel van wat je doet is de database. En de crux van optimaal gebruik van de database is en blijft SQL. Dit bepaalt performance en […]
0 0 Yesterday (16th October), 10 days of the end of the yearly Oracle show in San Francisco, AMIS organized its ‘Review from Oracle Open World 2012’ session with an overview of news, trends, announcements, special finds and interesting rumors . This session was ‘sold out’ (even though it was free). For […]
0 0 Yesterday evening we had the annual “We went to OOW and this is what’s new in the world we call Oracle” at AMIS. Starting around 5pm and ending around 10pm a lot of information was presented by several AMIS colleagues. My contribution to the evening was (amongst others) a little […]
0 0 Hierbij nodigen we je uit om met ons kennis te komen maken. Ben jij een (junior) Oracle consultant die een stap verder wil maken? Wil je verder groeien en ontwikkelen tot principal consultant? AMIS geeft je de kans om die stap te zetten. Bij ons krijg je de ruimte om […]
0 0 Database development in the Oracle Database is crucial for creating well balanced multi tier applications. This presentation describes a number of useful facilities and application architecture considerations around the database, taking into account some of the most recent insights. The official slide deck from this presentation at Oracle Open World […]
0 0 Question from one of my customers: “Please help me find an update statement that’s able to re-order a primary key after a delete.. and by the way.. you are not allowed to use PL/SQL, triggers or a sequence, because we cannot change anything in the app schema”. Updating a PK […]
0 0 Yesterday Bryn Llewellyn, Distinguished Product Manager, did a session called “PL/SQL Enhancements brought by the latest generation of database technology”. The room was packed. For the upcoming release of the Oracle 12c database the enhancements were broken into three areas: Improved PL/SQL and SQL interoperability In the current version of […]
0 0 Using Kaazing Websocket Gateway and OpenFire Scenario: If you, for example, have a webshop and a webshop online support application for internal use, this solution will let the webshop customer call in some help by using IM. The support application will react on the customer call by opening the support application […]
0 0 The show of the year is around the corner: on Sunday it will all start again, the Oracle Open World conference. Tens of thousands of developers, architects, administrators, project managers, decision makers and others involved with Oracle products one way or another are gathering in and around San Francisco. AMIS […]
0 0 This will be my third time attending Oracle Open World and I’m really looking forward to the event. It is very hard to make a schedule, there are so many good session available. I thought I’d share my schedule, it might inspire you for your own schedule (or makes it […]
0 0 Hierbij nodigen we je uit om met ons kennis te komen maken. Ben jij een (junior) Oracle consultant die een stap verder wil maken? Wil je verder groeien en ontwikkelen tot principal consultant? AMIS geeft je de kans om die stap te zetten. Bij ons krijg je de ruimte om […]
0 0 Oracle Open World is around the corner – with all the latest about Oracle products. In het hubbub of the latest and greatest, flashiest and news-worthiest, you may not expect Oracle Forms to play a major role. And to be fair: it will not have a major role at OOW. […]
0 0 Van 30 september tot 5 oktober is San Francisco weer het domein van tegen de 45.000 deelnemers aan de Oracle Open World en JavaOne conferenties. Ruim 2000 presentaties worden daar gehouden, in vele tientallen zalen in hotels en het Moscone Conferentie Center in downtown San Francisco, waaronder pakweg 20 door […]
0 0 This article will argue against the use of (stateful) global PL/SQL variables – as they are both a potential problem for stateless web applications and the availability experienced by end users during database upgrades. In various database releases, Oracle did a lot of work in supporting online redefinition of database […]
0 0 I wanted to compare the content of two tables with identical layout quickly with the minus set operator, but ran into a couple of errors, caused by clob and blob colums. As I found out, set operators ( union, minus, intersect ) in combination with clobs or blobs, are not […]
0 0 Tuesday May 15th, Nieuwegein – The Netherlands: During an intense day and evening, close to 120 Forms developers and architects gathered for discussions, explorations and exchange of experience around the use of Oracle Forms and more importantly: the future of the current Forms applications, Forms-using organizations and Forms developers. Various […]
0 0 Sporting a selection of the world’s best known speakers in the area of Oracle Forms and Forms modernization – on Tuesday 15th May AMIS will host an all day event around Forms, aimed at application architects and lead developers. During this event, we will discuss and demonstrate the most relevant […]
0 0 It has been more than a year since I published my previous blog on generating PDF with pl/sql. In that time I’ve rewritten as_pdf two times, so now its time for as_pdf3
0 0 SQL today is the foundation for any successful application. Whether it is a SOA implementation, an ADF or APEX application, a Forms application or any other usage of the Oracle Database (or any other relational database), SQL is key for the success. AMIS has embraced the evolution of SQL through […]
0 0 ‘COLLABORATE 12: Technology and Applications Forum for the Oracle Community’ is de grootste Oracle gebruikersgroep conferentie ter wereld en wordt jaarlijks georganiseerd in de Verenigde Staten. Het is hét evenement om bij te zijn wanneer je geïnteresseerd bent niet alleen in Oracle Applications (E-Business Suite, JD Edwards, Siebel, etc.) maar […]
0 0 Veel PL/SQL ontwikkelaars hebben (n)iets met Java. Aan de ene kant zien ze dat Java op veel plekken wordt gebruikt, binnen en buiten de Oracle technology stack. En dat kennis van Java af en toe best handig zou kunnen zijn – zeker als je als klassiek Oracle ontwikkelaar gebruik wil […]
0 0 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 after having a quick look in my agenda, regarding my free time, we started to set things up. This 2 day […]
0 0 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 toepast in zijn of haar werk. In deze Masterclass leidt Alex de deelnemers rond in Oracle Database 11g Release 1 en […]
0 0 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 XDB Repository, might have been impressed with its (GEO/KML Spatial, Image EXIF info) capabilities combined with Google Earth. This post will […]
0 0 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 […]
0 0 
