AMIS, Data Driven Blog – Oracle & Microsoft Azure
Getting value from IoT, Integration and Data Analytics
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 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 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 ‘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 Now that the UKOUG annual conference in Birmingham is over, it’s time to write my thoughts down. As this was the second time that I attended the UKOUG conference, I already knew that it is a big conference. Lots of great speakers and a very good agenda. On the agenda […]
0 0 When you create a “Report with Form”, there will be an icon in the report which allows you to navigate to  the form page. Only when the user clicks the icon this navigation will take place. For the current project, this was not what they wanted. They wanted to click […]
0 0 just so you know…
0 0 Yesterday I had the pleasure of attending a session by Connor McDonald. I heard a lot about him, his presentation style, and I even did a book review back in 2005. Everybody I talk to who attended a session by Connor – ever – is always very positive on his […]
0 0 Oracle Open World is underway. My first session, which I didn’t plan, was on Unstructured Data. There is a lot of unstructured data going around, as opposed to relational data, and it will only increase in the future. The number of images and videos will only increase in the future. […]
0 0 This post is more for me than it is for you, at least I will have a place to quickly check where am I supposed to be going next.The rest of this post is basically just my schedule for the upcoming week in San Francisco. Really looking forward to all […]
0 0 Op maandag 19 september zal er bij AMIS een Oracle Open World Preview sessie worden gehouden. Een groot deel van de Nederlanders die het dit jaar gelukt is om aanwezig te zijn als spreker op Oracle Open World zullen hun presentaties geven in Nieuwegein. AMIS-ers Lucas Jellema, Alex Nuijten, Peter […]
0 0 The business rule states: Only one entry is allowed per ID and per day and the time should be recorded. The table involved (simplified for the blog post) SQL> create table test 2 (id number 3 ,inspection_dt date 4 ); Wouldn’t it be nice if it was possible to do […]
0 0 Last week the yearly ODTUG KScope conference took place in Long Beach, California. I always need to time to let this wonderful event really sink in. The number of sessions and the wealth of information that you get is really quite extraordinary. In this blogpost I will highlight some of […]
0 0 Ook dit jaar, namelijk op dinsdag 14 Juni, organiseert AMIS de ODTUG Preview. Het jaarlijkse congres van de ODTUG, de Oracle Development Tools Users Group, vind dit jaar plaats in Longbeach, California van 26 tot en met 30 juni. Het is niet voor iedereen weggelegd om daar naar toe te […]
0 0 When you want to expose your Stored Procedure to the “outside world”, should you do this using XMLType? As always, the correct answer is “it depends”. For this example I will use a Package containing two functions, the signature of the package is as follows: create or replace package emps_pkg […]
0 0 Sometimes it is necessary to create a Stored Procedure which returns an XMLType, like when you want to expose the Stored Procedure to the “outside world”, like via a Mediator. There are several options to create an XMLType. In this blogpost I will show you two ways of doing this. […]
0 0 Yesterday evening we had our annual Oracle Open World review at our office in Nieuwegein. Around eighty people attended and all were very involved with the session. Five AMIS employees were at Oracle Open World, and each one covered one area of interest. Before dinner Lucas gave an overview of […]
0 0 In case you missed it (how is that possible?) last week was the annual ODTUG conference, Kaleidoscope in Washington DC. In this post I will share some of, what I consider, the highlights of this event. I always enjoy going to this conference, it’s nice to see old friends and […]
0 0 Voor het vierde achtereenvolgende jaar organiseert AMIS de “ODTUG Preview” sessie op 8 juni 2010 bij AMIS in Nieuwegein. ODTUG Kaleidoscope 2010 is een conferentie voor Oracle ontwikkelaars, dit jaar vanaf 27 juni in Washington DC. Deze conferentie trekt van oudsher veel Nederlandse deelnemers, waaronder een flinke afvaardiging van AMIS. […]
0 0 Last Tuesday we did a Preview of the upcoming OPP (Oracle PL/SQL Programming) Conference which will be held in Atlanta, Georgia soon. This preview took place in our office in Nieuwegein, The Netherlands. About 17 people attended this free preview. At regular intervals we do free “Knowledge Center” presentations. Keep […]
0 0 The Merge statement was introduced in Oracle 9i and improved upon in Oracle 10g. In Oracle 9i only the INSERT and UPDATE parts were supported, in Oracle 10g DELETE was added. The "merge_update_clause" and "merge_insert_clause" became optional. The basic syntax for the MERGE statement: DELETE can only occur in the […]
0 0 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 this conference, you are missing out on something great. A lot of great presentations, great food, lots of time to network […]
0 0 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 “tricks” that passes by is how to implement the Business Rule: Only one Clerk per Department is Allowed The way we […]
0 0 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 two days a lot of SQL subjects are reviewed. One of them is Subquery Factoring, better known as the “WITH clause”. […]
0 0 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 use a Virtual Column – a new feature of the Oracle 11g Database – to disect a composite value and use […]
0 0 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 started by saying the Oracle 11g Release 2 can be expected the end of this calender year. One of the things […]
0 0 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 going to sessions like these. One of the recurring themes was Instrumentation. During the Expert Panel a question was asked what […]
0 0 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 Nederland. Deze puzzel is gebaseerd op het verhaal van Carel-Jan Engel tijdens een AMIS Query over High Availability. Hij vertelde hoe […]
0 0 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 the time (if not all) “Because it’s easy if you want to comment out some of the conditions”. Say you have […]
0 0 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 einde van het jaar wordt het op de kleintjes letten. Een groot deel van je budget gaat op aan Sinterklaas- en […]
0 0 I just came across this website "I love PL/SQL, and…", one of Steven Feuerstein’s website. If you ever attended a seminar given by Steven, you already know that he always mentions to contact Brynn Llewellyn if you have ideas on how to improve the PL/SQL language.
0 0 The other day one of my colleagues asked me if it is possible to create a copy of a table with all the content in it. He wanted to do some experiments with it and didn’t want to mess with the original table. A simple CTAS (Create Table As Select) […]
0 0 If you are a regular user of the FORALL statement, you are probably also familiar with this message: PLS-00436: implementation restriction: cannot reference fields of BULK In-BIND table of records While I was playing around on our Oracle 11g database, I found that this restriction was lifted. How cool […]
0 0 Oracle SQL Developer offers the ability to create reports with graphs in it. A number of reports are included with the tool, unfortunately a report which shows information based on DBMS_PROFILER built in package isn’t there. DBMS_PROFILER allows developers to profile the run-time behaviour of PL/SQL code, making it easier […]
0 0 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. In dit on-line artikel kunnen alle scripts worden gedownload, zowel de DDL en data-load scripts, als scripts met mogelijke oplossingen. Ook bevat dit on-line artikel enkele […]
0 0 What is the most common way of testing PL/SQL code? I think it is using DBMS_OUTPUT and manually verifying the results. Is it the best way of testing code? No, I don’t think so, but it is the most common way. Steven Feuerstein created Code Tester, and if you are […]
0 0 Last week six of us at AMIS attended the ODTUG Kaleidoscope conference in Daytona Beach, FL. I always need some time to digest all the information that was presented so that’s why I am writing this Blog now. One of the sessions I really enjoyed was given by Eric Evans […]
0 0 This was the second time I needed to look up how to create an Index Organized Table (IOT) with a Create Table As Select (CTAS). So just a quick entry so I won’t forget…. or at least that I will know where to look. create table [table_name]( [col1] primary key, […]
0 0 During the Oracle PL/SQL Programming Conference in San Francisco another session I really liked was called "Contract-oriented PL/SQL Coding". In this blog I will go over the basic principles of Contract-Oriented PL/SQL coding as suggested by John Beresniewicz, who did this presentation.
0 0 Now that the OPP is over, it is time to look back on the most interesting things that I have heard for the last couple of days. The first thing that comes to mind is the keynote given by Steven Feuerstein, titled "Wake up and Smell the …". In this […]
0 0 
