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 outstanding, creative and innovative contributions to the Oracle PL/SQL Community."
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 San Francisco attracted about 300 programmers and DBA. At the end of the first day, a Test-a-Thon was organized. Together with […]
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 Programming Conference. After struggling over the armrest for nearly 11 hours I finally made it. The conference starts on wednesday, that […]
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. Congratulations Steven!
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 a Built-In package is plain silly. Sometimes however, the Built-In functionality is not what you expect it to be. For instance […]
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 system, SAP in this case. It was a type of “fire-and-forget” webservice. Oracle 10 offers UTL_DBWS to interact with webservices, but […]
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 first. Table script could not be generated because it is not possible to define a column of XMLType. What we did […]
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 plugins and I use these a lot. SQL Developer now also has the same plugins that I use, except the one […]
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 this sort of stuff, I need to write it down (I am getting older, you know) hence this blog. What I […]
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 a select-statement, a CTAS – Create Table As Select – that the select was executed prior to the creation of the […]
At the customer site where I work, we are using an Oracle 9i. More specific a 22.214.171.124 database. While demonstrating to one of my colleagues when an index can and cannot be used, I noticed something strange when I ran the same script on my laptop. My laptop has an […]
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 maintain the data.Changes to the configuration data were usually done during a maintenance window, and the activation date was set in […]
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 going on with an XMLType variable in my PL/SQL code, I wanted to use DBMS_OUTPUT to display the information in SQL*Plus. […]
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 have read the announcement on Dimitri Gielis’ Blog. Besides talking about his firm, Miracle AS– they also brew beer, he gave […]
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 in Oracle. At that time I was pretty sure there is no such a function in Oracle SQL. He told me […]
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 away using Analytic Functions when there is no need to do so. The example I give is the following: SQL> select […]
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 hierbij.
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 six people to attend. I was one of the lucky ones. In this blog I will describe some of the things […]
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 one of the first to respond. The original poster had a table with a content looking like: EMP Type_Phone Phone_num 0 […]
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 ringing at the same time. This is exactly what happened last week after an application upgrade. The release of the application […]
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 true: if it had a certain value the other column must be NULL. The first column had a check constraint defined […]
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 folder and restart FireFox.
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 van de Weghe of Oracle. My colleague Aino wrote a detailed blog on the evening. Oracle Text, Ultra Search and Enterprise […]
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 did. And I can tell you, it doesn’t give you a nice warm fuzzy feeling inside. A day’s worth of log […]
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 info can be found at the Publisher’s website. The source code is available for download.
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 of the book is nice, with progress checks to monitor how well you understand the chapter you just read and sample […]
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 ID from the most recent subscriptionâ€?. Hereâ€™s a sample from the list: ID, CAT, START_DATE, END_DATE 1, 0, 29-DEC-04, 17-JUL-05 2, […]
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 or you haven’t tried it yourself. The starting point to find Open Source Projects related to Oracle has always been the […]
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 chapter for download. This weekend I finished reading this book on Oracle SQL. So it’s time to write a review. After […]
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 structure included a LONG column. In the Target Database the column was a CLOB. Luckily for me Oracle provides a TO_LOB […]
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 also has an Oracle Plugin available. So, continuing the story on Oracle and Open Source, may I present to you: SQuirreL
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 a comment on Oracle Open Source: TOra (toolkit for Oracle). As promised I have taken a look at it and now […]
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 JavaDoc. This takes care of both objections. Generate the documentation so you don’t have to write it. You still have to […]
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.