Author: Alex Nuijten
During the Oracle PL/SQL Programming Conference, AMIS received an award for their contribution to the Oracle PL/SQL Programming Community. To be more specific, the award reads: "In recognition of …
Can you believe it? After a full day of different presentations on PL/SQL, people just couldn’t get enough of PL/SQL. The 2 day Oracle PL/SQL Programming Conference (OPP2007) in …
At 04:30 this morning my alarm went off. I don’t like mornings, but today is different from other days. Today I flew into San Francisco for the Oracle PL/SQL …
Just in time for the Oracle PL/SQL Programming Conference, OPP2007, the Code Tester for Oracle is released. I am very excited about this tool and more posts will follow. …
Yesterday evening I started preparing for the upcoming Oracle PL/SQL Programming Test-A-Thon. I strongly believe that building your own programs to perform a functionality, which is already provided as …
One of our clients asked us to help with calling a webservice from a database trigger. This webservice would duplicate the actions done by the database in a different …
At the site where I am currently working Oracle Designer is used. The version they have here, Designer 10, does not supprt XMLType and this posed a problem at …
SQL Developer released a 1.1 evaluation version a couple of days ago, which you can download here, and I noticed something very familiair. In Firefox you can have search …
Probably this is old news for all of you who have lots of experience with XMLDB, but for me this is something new. In order for me to remember …
Riddle me this: Can an object exist in all_objects before it is created?Well no, of course not. I was under the assumption that if you create a table with …
At the customer site where I work, we are using an Oracle 9i. More specific a 9.2.0.5 database. While demonstrating to one of my colleagues when an index can …
One of our tables stores configuration data. Two stored procedures interact with this table; One of them uses the data for further processing; The other procedure is used to …
I just got started using XMLType. I know maybe a little late to start to look at it, but better late than never, right? Anyways, to see what is …
Right after the Oracle Quiz Lucas and I presented last week on ODTUG, I went to Mogens Norgaard’s presentation. Here is a short report from that session, you may …
Last week at the ODTUG conference, I did a presentation on Analytic Functions. Later on someone came up to me and asked me if there is also a Median-function …
While preparing my paper for ODTUG, “One Analytic Function can do more than a 1000 lines of code” I stated that you should be careful not to get carried …
Eindelijk zijn ze er dan. De presentaties over het Seminar van Jonathan Lewis. In dit zip-file zitten de presentaties die Anton en Alex gedaan hebben. Ook zitten de demo-scripts …
When you startup JDeveloper, default it gives you a “Tip of the day”. I always enjoy reading these tips and I would like to share this one with you:
A little while ago, Jonathan Lewis presented a three day seminar in The Netherlands. You may have read other blogs on this site about this seminar. AMIS had sent …
A while ago on the SQL and PL/SQL forum on Oracle Technology Network someone asked a question regarding a pivot query. Because the question was justed posted I was …
Do you know what it sounds like when a production system comes to a grinding halt? It sounds like a telephone ringing. Actually it sounds like a dozen phones …
While working on a current project I ran into the requirement that a column was mandatory, depending on the value of another column. The other way ’round was also …
Following the Search Plugins for askTom and Oracle Docs, I created a search plugin for the Amis Technology Blog. Installation: Simply unzip the Amis Search Plugin in the Searchplugin …
Title: Beginning Oracle Programming Authors: Sean Dillon, Christopher Beck, Thomas Kyte with Joel Kallman and Howard Rogers Publisher: Apress ISBN: 1-59059-286-7 Publication Date: Sep 2003 Website: http://www.apress.com/book/bookDisplay.html?bID=253
Last week I attended a Theme meeting of the Dutch Oracle Usergroup (OGH). The topic was called “Zoek en Gij zult Vinden” (“Search and you will find”) by Wouter …
Did you ever find yourself in a situation where you accidently deleted a number of records which you shouldn’t have? And to top it off, committed the changes? I …
Title: Mastering Oracle PL/SQL: Practical Solutions Authors: Christoper Beck, Joel Kallman, Chaim Katz, David C. Knox, Connor McDonald Publisher: Apress ISBN: 1-59059-217-4 Publication Date: Dec 2003 Website: http://www.apress.com/book/bookDisplay.html?bID=276 More …
Title: Oracle Database 10g A Beginner’s Guide Authors: Ian Abramson; Michael Abbey; Michael Corey Publisher: McGraw-Hill Osborne Media ISBN: 0072230789 Publication Date: March 31, 2004 Website: http://shop.osborne.com/cgi-bin/osborne/0072230789.html The setup …
While working on a Project for one of our Clients, an interesting requirement popped up. What they wanted was the following: “From this list of dates, we need the …
I guess I must have been sleeping all this time… how did I miss this wonderful tool? If you raise your eyebrows now, you either disagree with this statement …
Title: Mastering Oracle SQL, 2nd Edition Authors: Sanjay Mishra, Alan Beaulieu ISBN:0-596-00632-2 Publication Date: June 2004 More info can be found at website of O’reilly. There’s also a sample …
Although not a “new” command in SQL*Plus, it’s very cool. Recently I had to move some data from one table to another in a different database. The Source table …
Not too long ago my colleague Zeger Hendrikse gave this presentation on Open Source Databases. Part of this presentation are the Tools available. One of the Tools he mentioned …
Even though I started a journey into the realms of Open Source software available for Oracle , I’m taking a small detour now. JDBExplorer was suggested to me via …
Everybody knows it. Documentation is essential. Most people hate two things about it. The first one is to create it, the second to read it. The Java community has …
Inspired by this article by Lucas Jellema I ventured to see what the “Open Source community� has to offer to an average Oracle-developer like myself.
![Going to SF, to meet SF]({"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"} "Going to SF, to meet SF")