OPP2007: Test-a-Thon

Alex Nuijten 1

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 […]

Going to SF, to meet SF

Alex Nuijten 2

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 […]

Never Assume, always test…

Alex Nuijten 8

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 […]

Transaction Dependent Webservice Invocation…or how to call a webservice from a database trigger and make the call part of the transaction

Alex Nuijten 3

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 […]

Disappearing Columns

Alex Nuijten 15

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 […]

Read Inconsistency?

Alex Nuijten 8

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 […]

A day with Jonathan Lewis

Alex Nuijten

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 […]

How Rownum can help you tune a Query

Alex Nuijten 3

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 […]

Analytical Power

Alex Nuijten 1

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, […]

Oracle Open Source: SQLTools

Alex Nuijten 5

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 […]

Oracle Open Source : SQuirreL

Alex Nuijten 1

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

JDBExplorer: a test-drive

Alex Nuijten 6

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 […]

Oracle Open Source : FoReDoclet

Alex Nuijten 26

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 […]