MERGE!
![MERGE!]({"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"} "MERGE!")
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 …
Category: PL/SQL
AMIS Query – Oracle BPEL Process Manager Dissected (Thursday 27th January)
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 …
Enabling Role-based security management in Oracle Designer 6i/9i/10g through the Repository Object Browser
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 …
Pivoting in SQL using the 10g Model Clause
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) …
Parallelizing Table Functions (instead of paralysing)
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 …
9.0.4.5 Maintenance Release Oracle Designer available
Today I discovered the 9.0.4.5 maintenance release for Oracle Designer 10g on MetaLink. It has been released on November 18th, so this is not hot news. The 9.0.4.5 is …
Oracle Open Source : SQuirreL
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 …
Table FUNctions: select a graph in SQL
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 …
Tom Kyte presenting in The Netherlands – 8,9 and 10 February
On February 8, 9 and 10, Tom Kyte will present a seminar – just around the corner, in Utrecht. See Seminar Details for details. The event is organized by …
SchemaSurf (Freeware) – Browser based tool to navigate the database
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 …
Making up records in SQL Queries – Table Functions and 10g Model clause
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 …
Tip for Oracle Designer API programming
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 …
SQL Script to empty out/cleanse a user schema
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 …
Interesting articles on various subjects
November 5, 2004
Database, IT, Java, Oracle, Oracle WebLogic Server, PL/SQL, Web HTML5 CSS3
1 Comment
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. …
Oracle (finally) announced release of Enterprise Planning and Budgeting
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 …
JDAPI misteries
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 …
JDeveloper BPEL plugin
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 …
Oracle Designer – on Design Editor performance and Repository Maintenance
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 …
Webforms Help page on OTN
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 …
DDL Wizard – freeware to extract DDL from Export-files (dump-files)
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 …
Performance guide-lines for XSL-T development
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 …
Analytical SQL Functions – theory and examples – Part 1 on the Partition Clause
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 …
Trick for multiple and flexible parameter passing with MOD_PLSQL and Web PL/SQL toolkit
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 …
Eating your own dogfood – use of Oracle Development tools within the Oracle Applications development group
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 …
ADF documentation
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 …
Oracle Open World
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 …
AMIS Query: The Future of Oracle Designer (and other tools)
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 …
Oracle Designer – a tip for Generation of Forms – Enforce Post Generation
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 …
The future of CDM RuleFrame – the Oracle framework for server-side business rules
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) …
Report of Webforms evening
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 …
HTML-DB at a glance
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 …
JDBExplorer: a test-drive
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 …
Oracle Open Source : FoReDoclet
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 …
Oracle Open Source : TOra (Toolkit for Oracle)
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.
PLDoc release 0.8.2 Available
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 …
End of an era (for me): Oracle SCM State of Direction
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. …
Oracle Designer/Oracle SCM Meta Model
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 …