PL/SQL Profiling
How do you trace performance issues and bottlenecks in your PL/SQL applications? Since 8i the Oracle database has been equiped with the profiling tool dbms_profiler. It is quite simple …
Category: Oracle
10gR2 New Feature: DML Error Logging
Just read an excellent overview of the new 10gR2 feature of DML Error Logging: 10gR2 New Feature: DML Error Logging by Natalka Roshak on Oracle FAQ’s. It gives a …
Improvements in Oracle SCM Check Out and Check In mechanism (better Oracle Designer Source Code Control)
![Improvements in Oracle SCM Check Out and Check In mechanism (better Oracle Designer Source Code Control)]({"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"} "Improvements in Oracle SCM Check Out and Check In mechanism (better Oracle Designer Source Code Control)")
Oracle SCM – the Software Configuration Manager – provides the backend source code control services for Oracle Designer. It offers among other things functionality for Version Control: Check In, …
Book Review: Pragmatic Unit Testing
September 20, 2005
Book reviews and Publications, IT, Java, Oracle, Oracle WebLogic Server
No Comments
Title: Pragmatic Unit Testing Authors: Andrew Hunt, David Thomas ISBN: 0-9745140-2-0 pages: 150 This book gives a good introduction into the different aspects of unit testing. It’s easy readible …
AJAX Tag Library – Open Source project for easy use of AJAX mechanisms from JSPs
I just googled across this open source project. It is relatively simple, but can be quite useful. Its demos are at any rate useful, if only for the JavaScript …
Enhancing PHP-based WordPress Weblog with AJAX driven enrichments
Over the past period I have written several articles on AJAX – the Asynchronous JavaScript and XML mechanism for dynamically updating a web-page based on background communication with the …
Increasing speed of making data available in the web-page – on AJAX, controlling data caching and JavaScript Libraries
The problem I am dealing with: downloading all data that is potentially to be displayed in the client – for example in SELECT LISTS – takes too long to …
Building Check In protection into Oracle Designer/Oracle SCM – Check In only by the user that did the Check Out
One of the peculiarities – that word once took me three minutes to pronounce more or less correctly during a workshop in Melbourne, Australia and I vowed never to …
Oracle 10g R2 does not support Oracle Warehouse Builder.
Oracle’s latest database release 10g R2 does not support OWB (Oracle Warehouse Builder). All OWB’s up to and including the current version 10.1.0.3 are not certified by Oracle 10g …
An Introduction To Ajax – great article on dev2dev
I just came across an article that very clearly introduces AJAX: An Introduction To Ajax Recently I did an internal presentation Enhancing Web Applications with AJAX, XMLHttpRequest, UIX – …
Standard for Database Development – Getting rid of USER from PL/SQL and SQL – no longer is USER equivalent to End User
Many applications built in the Client/Server era made use of the fact that every end user had his or her own Database User Account and every Database Connection and …
VPD part 2; The added functionality in 10g
In my prior post about VPD I stated that VPD is not a new functionality Oracle added to 10g Enterprise Edition. In fact it was already available in the …
Introducing Spring Framework – Overview presentation and demonstration for Oracle Consulting
Last week, I had the opportunity to present on the Spring Framework for the Oracle Consulting Java Professional Community at Oracle The Netherlands. Having worked at Oracle for over …
Virtual Private Database, securing your data
I was not that aware of the fact that there were other (better) ways to secure data without using functions in views until I was involved in a project …
SQL Question: Find overlap in periods – using Analytical Functions (LAG and LEAD)
Today one of my colleagues asked me “What again was your query for finding overlaps in a table with periods, demarcated by start_date and end_date. I think he was …
Spring and Oracle ADF – registering a POJO Spring JDBC based Business Service as Data Control
In several previous posts, I have wondered about the potential for combining the ADF Binding Framework and the IDE capabilities around ADF in Oracle 10g JDeveloper with the Spring …
Firefox Search Plugin for Amis Technology Blog
Following the Search Plugins for askTom and Oracle Docs, I created a search plugin for the Amis Technology Blog. Installation: Simply unzip the Amis Search Plugin in the Searchplugin …
JHeadstart Sighting: Steve Muench's Column in Oracle Magazine – Frameworks: Creating Search Pages
Swinging in the sun, enjoying one of this Summer’s last great days perhaps, I was reading the September/October issue of Oracle Magazine. One the interesting pieces this issue was …
Repository Object Browser – Invoking the full property palette for any secondary element
The Repository Reports in the Oracle Designer web-interface Repository Object Browser provide an overview of the most useful properties of the most important components of the elements in the …
Role of the Database in a J2EE Architecture – Dumb Data Store? Only Data Tier? Also Business Tier?
The other day, we had a very interesting debate about the role of the database in (our) Java/J2EE projects and architectures. Should you limit the use of the database …
Introducing Spring JDBC – frequently the best introduction of Spring in an organization
Spring consists of a number of modules, such as the IoC Container, AOP, MVC, Persistence, DAO and Remoting. These modules are relatively losely coupled: some can be used without …
JUnit testing with EasyMock
Mockobjects are the classic solution to the even more classic problem of how to test code in isolation, when that code needs other objects to perform its tasks. The …
On Line Documentation for Oracle 10gAS 10.1.2 – including ADF Documentation
For the on-line documentation for release 10.1.2 of the Oracle Application Server, see http://download-uk.oracle.com/docs/cd/B14099_10/web.htm. It contains besides others links to documentation on the ADF (Application Development Framework), such as …
Building Custom JSF UI Components – Article Chris Schalk TheServerSide.com
Today I read this very interesting article by Chris Schalk – responsible for the Web application development features within Oracle JDeveloper- TheServerSide.com – Building Custom JSF UI Components. Chris …
Integration between Repository Object Browser and Headstart Utilities Quality Reports
The Repository Object Browser is a valuable web-based interface to the Oracle Designer and SCM Repository, as I discussed in a recent post: Installing the Oracle Designer Web Interface …
Installing the Oracle Designer Web Interface – Repository Object Browser (dig up that little nugget)
One frequently overlooked component of Oracle Designer is its Web Interface: the Repository Object Browser. Added in 2003 to Designer 6i and 9i as well as in 2004 to …
Some small improvements for CDM RuleFrame (including code)
After a year full of stuff like Spring, UIX and ADF, JHeadstart, Struts and JSF, XSL-T and the likes, PL/SQL and SQL, I had a bout of nostalgia this …
Book Review: Beginning Oracle Programming
Title: Beginning Oracle Programming Authors: Sean Dillon, Christopher Beck, Thomas Kyte with Joel Kallman and Howard Rogers Publisher: Apress ISBN: 1-59059-286-7 Publication Date: Sep 2003 Website: http://www.apress.com/book/bookDisplay.html?bID=253
Enhancing Web Applications with AJAX, XMLHttpRequest, UIX – Report from An AMIS Ten Minute TechTalk
I was kindly requested recently to do a brief – and it was stressed several times that it really had to be brief, not something I am particularly well-known …
OERR – In search of Error Messages/Events
Sometimes you want to search for Oracle database messages, their meaning or you are in search of specific database event settings. For instance, a long time ago i was …
Powercharging FireFox using GreaseMonkey
Today I discovered GreaseMonkey mozdev.org – greasemonkey: home. Greasemonkey is a Firefox extension which lets you to add bits of DHTML (“user scripts”) to any web page to change …
IBM Open Sources WebFountain (UIMA) – Unstructured Text Analysis software
It sounds intriguing. If only I could really get it. IBM has developed software, called UIMA for Unstructured Information Management Architecture, that can be used for analysis of unstructured …
Bizgres 0.7 Released – Open Source platform for Business Intelligence and ETL
I just read in a Dutch IT magazine (Computable) about the release of Bizgres 0.7. Bizgres is an open source project: The Bizgres Project (www.bizgres.org), a Greenplum-sponsored, community-supported, open …
Oracle Lite Part 1, how to get started
This post is the first one of a set that I will write about Oracle Lite. I have been working with Oracle Lite and I am impressed. Not by …
Hierarchical query with nodes from different tables – DEPT and EMP nodes in one tree
Hierarchical queries using CONNECT BY logic are discussed quite frequently. Often in terms of EMP, the famous demo table that has a self referencing foreign key – MGR to …
AMIS WebLog crosses the 500,000 marker – half a million post-reads in just over a year
Yesterday we – that is: this AMIS Technology Weblog – had our 500,000th post-read. Over half a million times, someone has read one of our articles! The AMIS Technology …
Bill of Materials and Hierarchical Queries – Which Component contains a component that…
My two previous posts discussed presenting data in a tree-like fashion and filtering hierarchical data sets on certain query conditions while still returning a tree-like result set. This post …
Selecting a 'pruned tree' with selected nodes and all their ancestors – Hierarchical SQL Queries and Bottom-Up Trees
Hierarchical queries return data in a tree like structure. The query is performed by walking the tree that is made up of parents and children, each non-root-node linked to …
Great Oracle Forms 'plugin' – multirecord table column resize/sort/move around
Developed by Francois Degrelle, this is a great enhancement for any Oracle Forms 9i or 10g application: a simple to install plugin that allows users to resize columns in …
Use Data Tree in List of Values Window – ADF BC and UIX and JHeadstart
Recently I have had several occasions where I had to implement a List of Values, allowing the users to select a value from a large set of reference values. …