Category: Languages
Tuesday, May 22nd, AMIS hosts another very interesting AMIS Query event: Wilfred van der Deijl (Eurotransplant) will demonstrate his ingenious method of integrating Oracle Forms (web forms) with HTML …
With the series on SQL based Charts, I can now safely commit any crime in the firm knowledge that an insanity plea will undoubtedly be accepted. After spending way …
I may be at JavaOne 2007, the important work still has to go on. Hence the latest in a series of SQL powered charts and graphs: the Gauge or …
There are many things that can help make this world a better place. A pure SQL-based Gantt-chart is not one of them. However, that is exactly what this article …
A great example of how one could use the Oracle XMLDB functionality in a unforeseen way in your relational world, is being demonstrated by Laurent Schneider in his article …
It seems innocent, a few lines of code used twice in the same application. But before you know know it those lines appear 272 times in your application! You …
Much has been written on how to trace database sessions through a java application in all sort of different techniques. Since Oracle 10g a new technique is added to …
Allright, that is an exaggeration. Hugely. But it cost me some headache before I realised what was my problem. I still had HTML DB 1.6 running and I thought …
Is Jinitiator going away I am wondering for a long time. Especially now the the Sun JPI can easily be used with Web Forms. My colleague Marco pointed me …
If you want to write a program to solve sudokus, you can use almost any programming language. And PL/SQL too!
Sometimes you are writing some codes and things really come together well. Let’s imagine, you are writing a little tool in ApEx for registering hours on a project. The …
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 …
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 …
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 …
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 …
During OPP 2007, two presentations by Ken Atkins where given regarding XML(DB) items, featues and best practices. My collegae Alex Nuijten was also attending, and presenting, and hinted me …
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 …
A few weeks ago one of my customers told me that he lost a sales opportunity because the customer who he was trying to sell his software too had …
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. …
A quite common concept in many programming langiages, though perhaps strongest in Java, is the String Tokenizer. This is a utility class or function that takes a String as …
Today I all of a sudden found myself investigating the creation op PL/SQL based Data Services, returning XML documents with data from SQL queries to HTTP Clients. The direct …
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 …
After receiving a new, pretty powerful laptop, on Thursday and installing the Oracle BI Enterprise Edition on Friday, this weekend sees my first steps with the BI Publisher (previously …
This problem probably sounds very easy and it is actually very easy, but it took me so long to figure this out I think it’s worth a blog. I’ll …
Introduction I have been investigating Oracle’s Web Service Manager recently. WSM is shipped with the new SOA Suite. The WSM is a service gateway. Existing services can be placed …
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 …
Last week I experimented with XML-Publisher a bit. The goal was to figure how to built a matrix report with simular layout as an Oracle Reports matrix report. Would …
Why Oracle Forms and BPEL? Old style Forms applications normally don’t hold much workflow functionality. Sure there is an order in which the forms should be used. The workflow …
IE 7 Webforms jvm.dll crash
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 …
From time to time, people on the OTN XMLDB forum, ask if it is possible to connect via the Oracle Protocol Server (aka the Oracle Listener), for instance in …
Last year I attended the Flex presentation by Waldo Smeets and played with the beta. I even gave a presentation and workshop about Flex at Amis, so there was …
One of the challenges of developing (J2EE) applications is information. It’s very hard to have an overview of the different components, objects, database tables etc. and how they interact. …
Brace yourself for yet another pretty useless demonstration of the unexpected wonders of SQL as well as my apparent lack of meaningful things to do with my life. Undoubtedly, …
This is probably described many times before, but you just can’t have enough example code snippets. Imagine you want to restrict users to update records which end-dates are in …
While writing useless queries for solving exotic challenges, I realized that the use of dummy tables or unions of selects against DUAL for producing a few data-rows is a …
Yesterday we ran into Oracle bug 1004056 while coding a module for a customer. I hear people think "Oracle Forms 60 that’s old". Yes it is but it is …
You probably know Google Suggest or one of its derivatives. An input item on a web-page or another user interface where you can enter a value that all of …
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 …
![Why you should never ever copy code – An example of complete chaos]({"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"} "Why you should never ever copy code – An example of complete chaos")