Category: Oracle
I have some vague plans for presenting statistics using SVG and a World Map. I was thinking for example about the spread of the visitors of our Website across …
During the last few years I have had several occasions to wonder who used the website and web-applications I had helped develop and deploy. Most recently I had this …
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 …
One of the Christmas presents from Oracle this year was the release of the 10g Business Intelligence tools. Most interesting among them was probably the long awaited Drake release …
SVG in combination with XML/XSLT is a tremendously powerful architecture to produce dynamic charts based on XML data – that can easily be generated from databases such as Oracle …
In July 2004 we at AMIS started this Weblog. Initially we primarily wanted to share knowledge among all people working at AMIS. Later we decided to make the Blog …
When working on a project I like to precompile my JSPs just to test if haven’t made any (syntax) errors or forgot any resources, without having to deploy them …
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: …
Leon van Tegelen
January 4, 2005
AMIS, Announce / Events, Development Tools, IT, Java, Oracle, Oracle WebLogic Server, Tools, Web HTML5 CSS3, Web/Java
For some time now there have been some excellent viewlets on OTN on the functionallity of the next generation JHeadStart version which will work with Oracle Application Development Framework …
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 …
This post discusses how data retrieved from a MySQL or Oracle database using the JSTL SQL tags is processed as XML document, transformed using XSL and rendered as SVG …
On the 7th of December, I, a database administrator, had a seminar from Mr. Chris Date about “Relational Remodeled” (into the 21st century with the relational model: a technical …
Introduction Although UML 2.0 is not completely new, I was not able to have a look at it until now. For people like me, and for other people who …
While working on more advanced Statistics Reporting for our weblog, I did some investigations into JSTL and more specifically the XML and SQL tags. Yes, I know I have …
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 …
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 …
An interesting problem we were working on some time ago is the following: a JHeadstart application – release 9.0.4.5 created with UIX, BC4J and Struts, JDeveloper 9.0.3 – has …
Title: Oracle Database 10g New Features – Oracle10g Reference for Advanced Tuning and Administration Authors: Daniel Liu, Don Burleson, Madhu Tumma, Mike Ault Published by: Rampant Tech Press ISBN: …
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) …
Last Friday we enjoyed one of the special privileges we have in our partnership with Oracle in The Netherlands – we have a private session on one of Oracle’s …
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 …
Last Thursday evening was special. On the occasion of Chris Date’s visit to The Netherlands, the product marketing department of Oracle Netherlands had gathered some 25 odd (could also …
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 …
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 …
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 …
Last week we received another shipment of books for our evergrowing library. Among this shipment were these titles:
The Oracle JDeveloper release 10.1.3 Developer preview release can be downloaded from OTN. See JDeveloper Homepage “The Oracle JDeveloper 10g (10.1.3) release adds many new features, including a new …
Every once in a while for no apparent reason a JDeveloper ADF/Struts project gets corrupted. When compiling the project I get an error that a certain class cannot be …
On OTN there is an excellent online seminar (replay) on the TopLink Object-to-XML support. This feature, which will be available in the upcoming 10.1.3 release, allows converting XML files …
If you’ve created a J2EE JHeadstart/BC4J application and you want to deploy it to the Oracle Application Server, it works easily. If you want to deploy it to IBM …
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 …
During development it is sometimes necessary to able to run your webapplication under SSL. To obtain a test certificate from verisign can sometimes take a little too much time …
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 …
In one of the projects I’m involved in we have to make use of specific Oracle JDBC features. The application runs on Tomcat 5.0.27 and connects to the database …
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 …
Last year I spent a lot of time on a project using Eclipse as IDE. I like it very much. I allways call it a real developers tool. It …
The Java Authentication + Authorization Service (JAAS) provides a standard API for making non-standard (i.e. custom) realms available to your application server, see e.g. this article on JavaWorld. To …
This post is the sequel to AMIS publishes a ViewObject Copy tool – JDeveloper 10g Extension (plugin) for ADF Business Components that we released last week. That post announced …
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 …
![Comment from Steven Feuerstein]({"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"} "Comment from Steven Feuerstein")