As in most project the need for a representable test data set existed in a recently started one. The data was available in a small MS Access database (7 tables). In this case a two step conversion was chosen. The first step was to use Oracle Migration Workbench (Release 10.1.0.2.2) […]
Last week, I sat with six colleagues at the AskTom Live – seminar with Tom Kyte. You can see us sitting here in the frontrow. You may have seen several posts on this seminar already. Here is my contribution, with things I noted down that struck me, seem useful to […]
I have written a number of posts on alternative, far fetched usages of Table Functions. My all-time high thusfar was a post titled Table FUNctions: select a graph in SQL . Now, I think I have reached another level in irrelevancy – though I have to admit it gives me […]
In a previous post Making up records in SQL Queries – Table Functions and 10g Model clause I discussed how you can make use of either a Table Function or the 10g SQL Model Clause to make up records in queries – as alternative to using a large table or […]
Organizations currently using JHeadstart 9.0.4.x or 9.0.5.x (for JDeveloper 9i or JDeveloper 10g (9.0.5.x) may wonder whether and when they should pick up the soon to be released ADF JHeadstart release. Moving towards the latest technology has a certain appeal as well as a scare factor. I will try to […]
This post discusses how a Web Service can be published based on a PL/SQL Package inside the Oracle Database – using Oracle 10g JDeveloper. In this article we will create a PL/SQL based WebService based on the Package we discussed in previous posts Consuming Web Services from PL/SQL – Part […]
This post discusses how a Web Service can be consumed from PL/SQL inside the Oracle Database through the use of the UTL_HTTP supplied package. In this article we will create a PL/SQL Function that builds the entire SOAP message, inserts parameter values, invokes the WebService through UTL_HTTP and returns the […]
I have recently used the LOG4PLSQL software for logging in a small application. I missed the possibility to change the logging level at runtime. In the production environment code changes are only allowed during specified deploy time windows, so changing the DEFAULT_LEVEL parameter in the PLOGPARAM package specification was not […]
Recently I installed Oracle Designer 126.96.36.199 – a maintenance release, released on November 18th. Previous releases were 10g (188.8.131.52) and patch release 184.108.40.206. All these releases contain a new feature, called Publish Diagrams. This feature allows you to export diagrams in Oracle Desiger – such as Entity Relationship Diagrams or […]
Tonight I completed a paper on using JDeveloper as a tool for Database Design and Generation as well as PL/SQL Development. This paper is in Dutch and will be published in the January issue of Optimize, the Dutch Oracle Professional Magazine. The article also briefly introduces two open source tools […]
Yesterday I needed to validate some XML against a schema definition. I had a tool for that at hand, but alas, it failed to work. Looking for another way to do it I came across this site where you can check the validity of the xml online.
In the Oracle Magazine of januari/februari 2005 Steven Feuerstein wrote an excellent article about Refactoring for PL/SQL Developers. In this article he uses technologies known in the Java community: Refactoring of code, and reapplies these in PL/SQL. Both languages are programming languages so it is perfectly OK to interchange the […]
When I was confronted with the challenge to import about 260 tables from two different Rdbâ€™s into a single Oracle database (9.0.1.x) on a daily basis via a database link my first thought was: Oh no, I am not going to write 260 times two individual DML statements, one UPDATE […]
BPEL is emerging as the standard for assembling a set of discrete services into an end-to-end process flow, radically reducing the cost and complexity of process integration initiatives. The Oracle BPEL Process Manager offers a comprehensive and easy-to-use infrastructure for creating, deploying and managing BPEL business. Oracle BPEL PM has […]
Managing users and privileges on countless folders and application systems, configurations and workareas as is the job of the Repository Administrator can be quite a task. Each privilege on every container-object needs to be manually assigned and revoked. If a new developer enters the project, with exactly the same set […]
In this post we discuss pivoting of records in SQL – either splitting or merging records. Typically this is done using PL/SQL based Table Functioins, UNION (for splitting records) and fairly complex, tricky SQL statements. In Oracle 10g, using the MODEL clause, there is a clean, fairly straightforward way to achieve elegant pivoting – even nested pivoting – in single SQL statements. This post shows the pivot operation using the Model clause.
In this post I explore the parallel execution of Table Functions. I was told it could be done, I have seen the examples and now I have tried it myself, using my single CPU machine running XP and Oracle 10g Database (Enterprise Edition). Parallel Execution proves to be an enormous performance boost – in certain circumstances.
Today I discovered the 220.127.116.11 maintenance release for Oracle Designer 10g on MetaLink. It has been released on November 18th, so this is not hot news. The 18.104.22.168 is not yet available on OTN’s Designer Software Page, there you will still find 22.214.171.124. If you have an existing Designer/SCM 10g […]
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
You may seen some enthousiastic ramblings on Table Functions in earlier posts I have written. This is another one. With approximately 50 lines of code, you can select crude graphs for any query. For example, a graph that indicates the total salary sum for the three departments in the SCOTT […]