Category: Languages
Perhaps SchemaSurf from Cobblesoft – FREEWARE – is worth a little investigation. SchemaSurfTM is a browser-based tool for querying your Oracle database schemas. Unlike most other tools, SchemaSurf does …
From time to time there is a need in my SQL queries to have access to a table with a specific number of records. Sometimes I want to explode …
Today I was at a customer site where we discussed programming using the API for Oracle Designer and Oracle SCM. I demonstrated the F5 function key in both the …
OK, it is a fairly trivial task. But when you have to prepare for workshops etc. it may take a lot of time to purge/cleanse/empty all student’s schemas without …
In this post I collect references to interesting articles on a variety of topics – Java, SQL, Business Intelligence, Web Services, HTML/CSS, JavaScript – that I have come across. …
From both the Oracle website as well as Mark Rittman’s weblog the release of Oracle’s new enterprise level Business Intelligence product Enterprise Planning and Budgetting was announced. This tool …
After working some weeks with JDAPI strange features are emerging. JDAPI seems to be unable to save PLL modules! Trying this results in This module type does not currently …
Today I attended an excellent online Oracle Seminar on the BPEL Process Manager by Sandor Nieuwenhuijs. I think most of the content is covered by a previous post by …
Yesterday it was an almost nostalgic day. For several years – primarily in the late 1990’s – I was heavily engaged in everything to do with Oracle Designer, its …
Here is an excellent web page about Oracle webforms. It covers the Forms Server, lots of general stuff, how to implement java (PJC and beans) in your webform and …
Thanks to Mark Rittman’s blog: The Oracle Export File DDL Extract Wizard What Does the DDL Extract Wizard Do? The DDL Extract Wizard will reverse engineer Oracle Export files …
To understand how Analytical Functions are used in SQL statements, you really have to look at the four different parts of an Analytical ‘clause’: the analytical function, for example …
XSL-T transformation for Oracle developers. When transforming XML with XSL-T stylesheets you should consider the performance of your transformation. Analog to tuning the Oracle database, XSL-T transformations can and …
To understand how Analytical Functions are used in SQL statements, you really have to look at the four different parts of an Analytical ‘clause’: the analytical function, for example …
This tip comes from a very interesting paper by John Flack. It is titled MVC Development in PL/SQL and appeared in the August issue of the ODTUG Technical Journal …
During the Amsterdam stage of the Oracle Open World Tour, I had a great opportunity to interview John Wookey Senior Vice President, Applications Development at Oracle Corporation. John is …
In between sessions on Oracle Open World I visited the demogrounds. In one of the booths Duncan Mills was demonstrating Oracles ADF framework in JDeveloper 10g. IMHO the documentation …
Today I visited Oracle Open World in Amsterdam, here are some of the points I picked up. In the “Oracle Application Server 10g Technical Overview” session David Keene gave …
Yesterday, we had another AMIS Query session titled The Future of Oracle Designer. It discussed the future of Oracle development tools, more specifically Oracle Designer and Forms as well …
During our session on the Future of Oracle Designer yesterday I had a conversation with Josef Megens of Oracle Consulting and told me of a trick conceived by Mark …
In this post I will discuss some thoughts I have on the further development of CDM RuleFrame (the Framework for implementing Business Rules). It seems to me that a) …
The Knowledge Centre Designer & Forms has had a meeting on the 30th of august 2004. The theme of this evening was Webforms. First there was a short overview …
Today I tried to put all my biases (I’m a j2ee developer) aside, and had a look at HTML-DB. “Oracle HTML DB is a declarative web-based application development environment …
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.
At 21st July 2004, release 0.8.2 of the PLDoc open source project for generating JavaDoc style documentation for PL/SQL Code (and now also Tables and Views) was published. PLDoc …
It does not come as a great surprise, yet I feel sad. Oracle’s Statement of Direction on Oracle SCM declares the product ‘dead as a dodo’. Well, not quite. …
This post – or rather its comments – contain some investigations into the Designer 9i/10g Meta Model and Meta Meta Model. That is: the tables that contain the definitions …
![Making up records in SQL Queries – Table Functions and 10g Model clause]({"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"} "Making up records in SQL Queries – Table Functions and 10g Model clause")