Writing a pure SQL based String Tokenizer
![Writing a pure SQL based String Tokenizer]({"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"} "Writing a pure SQL based String Tokenizer")
A quite common concept in many programming langiages, though perhaps strongest in Java, is the String Tokenizer. This is a utility class or function that takes a String as …
Category: Database
Never Assume, always test…
Yesterday evening I started preparing for the upcoming Oracle PL/SQL Programming Test-A-Thon. I strongly believe that building your own programs to perform a functionality, which is already provided as …
Using the Spring DataBinder to map Strings to objects
The Spring DataBinder is not only useful to bind request parameters, you can also use the DataBinder on other parameters, like command line arguments, JSON objects coming from an …
Sizing Oracle EBS 12i
I wanted to find out how ‘big’ the new Oracle EBS 12i release really is. So, I downloaded the software from Edelivery and created a stage area. From the …
Transaction Dependent Webservice Invocation…or how to call a webservice from a database trigger and make the call part of the transaction
One of our clients asked us to help with calling a webservice from a database trigger. This webservice would duplicate the actions done by the database in a different …
FNDCPASS ALLORACLE
FNDCPASS is an EBS tool to change passwords of database schema’s within the Oracle EBS. For example, you can change the APPS password using FNDCPASS, but also any other …
Upgrading EBS 11i database (9.2.0.6) to 10GR2 database
I have upgraded my EBS 11.5.10 database (9.2.6.0) to release 10gR2 (10.2.0.2.0). I have followed note 362203.1 from Metalink to perform the upgrade. Here are some tips or problems I …
SQL Tracing in Self Service Applications (CRM) within Oracle Applications 11i
In a lot of cases it is very interesting to be able to trace Self Service Applications (CRM) in Oracle Applications 11i. Most of the time it is very …
RAC vs. Data Guard or "Political High Availability"
Thursday 14 december 2006, we had here at AMIS a Query called "High Availability: RAC vs. Data Guard" the Query was lead by Oak Table Network members Carel Jan …
Disappearing Columns
At the site where I am currently working Oracle Designer is used. The version they have here, Designer 10, does not supprt XMLType and this posed a problem at …
APEX installation via the Oracle Protocol Server (listener)
From time to time, people on the OTN XMLDB forum, ask if it is possible to connect via the Oracle Protocol Server (aka the Oracle Listener), for instance in …
Security as a Individuals footnote
I have written this article over and over again, looking for a way to keep the depth of technical information leveled for the intended audience. I found it almost …
Master Class Jonathan Lewis Cost Based Optimizer
A couple of weeks ago I was at a MasterClass from Jonathan Lewis about the Cost Based Optimizer. It was a very interesting two days and I like to …
A session you must attend – How to best achieve High Availability for Oracle Databases with Carel-Jan Engel and Jeroen Evers
As you can see in the announcement on the top of this page – tomorrow we will host the most exciting DBA event of the year: the AMIS Query …
Performance Problems in RAC cluster 9.2.0.7
A short time ago I was asked to checkout the performance of an 4 node 64 bit linux RAC cluster on 9.2.0.7 RDBMS. After a short investigation I found …
Writing a Word Search puzzle solver in SQL
Brace yourself for yet another pretty useless demonstration of the unexpected wonders of SQL as well as my apparent lack of meaningful things to do with my life. Undoubtedly, …
Installation of Oracle Enterprise Linux on VMWare
Recently, Oracle announced and released it’s Enterprise linux. Time to check out what’s it all about! While downloading the software from OTN, I was surprised to see there were …
Myths on bitmap indexes
Although bitmap indexes are already available in Oracle 8i or even before (some sources even say 7.3!!!), they are still surrounded by many myths. Time for some clearing up. …
Changing the prompt dynamically in SQL*Plus
This is just a simple trick which is not well-known but makes life easier when using the good ol’ SQL*Plus commandprompt (and many people still do!). If you set …
Dummy data without dummy tables – just a little SQL trick with the TABLE operator
While writing useless queries for solving exotic challenges, I realized that the use of dummy tables or unions of selects against DUAL for producing a few data-rows is a …
Invitation for AMIS Query (14th December) on High Availability: RAC vs. Data Guard with Oak Table Network members Carel Jan Engel and Jeroen Evers
AMIS is proud to announce our next AMIS Query (free technical seminar), targeted at Oracle Database architects en DBAs: Oracle Database High Availability – RAC and Data Guard go …
The SQL Query to power Google Suggest
You probably know Google Suggest or one of its derivatives. An input item on a web-page or another user interface where you can enter a value that all of …
Pimp you SQL Developer
SQL Developer released a 1.1 evaluation version a couple of days ago, which you can download here, and I noticed something very familiair. In Firefox you can have search …
How to start/stop OC4J-standalone as a Windows service
In one of the previous blog-articles a colleague of mine described how to start an OC4J-container on the command line. Which was and is correct, but… I’m a database …
OOW2K6 – Keynotes and Presentations
Most of the Keynotes and Presentations of Oracle Open World 2006 can be found here: http://www28.cplan.com/cc139/catalog.jsp As it says in smaller lettertype just below…easy to overlook… To download presentations, …
Oracle Enterprise Linux available [ for free! ]
Oracle Enterprise Linux is now available from the Oracle unbreakable 2 program and ISO’s can be downloaded for free – see Sergio’s blog here: http://www.orablogs.com/sergio/archives/001838.html. I heared from Dimitri …
OOW2K6 – Unbreakable Linux – The next stage
Unbreakable Linux and updates on upcoming 11g release Mr. Larry Ellison's keynote blew everything of the table for today; at least it did for me and let's be honest, …
Worst practices when using Oracle JDBC Drivers – great presentation by Douglas Surber
I just came out of – well actually, as I am writing this down I am still in it – a very good session on the Oracle JDBC drivers …
OOW2K6 – and Mr. Kyte has left the building…
Tuesday - Getting into the spirit I am just joking, so far I haven't seen an Elvis look-a-like in town, but I would be very interested how Thomas Kyte …
OOW 2006: Keynote speech at Oracle Develop by Thomas Kurian
Yesterday (Monday) was the Keynote speech by Thomas Kurian, Oracle VP, that started the Oracle Develop event. In what can be described as a crisp, well organized presentation, Kurian …
OOW2K6 – Newbie impressions…
It's amazing how much Lucas already put to "paper", despite all the mishaps we already encountered. The last two days I lost track on Lucas because he has completely …
A room full of Oracle ACEs…
Last night we had the annual Oracle ACEs dinner at a very nice San Francisco restaurant. The food and wine were excellent, but the company even more inspiring. I …
On the false sense of security with PL/SQL based implementation of business rules – and what to do about it
Building applications in our corner of the world typically revolves around databases. The most important bit about an application is not the application, but rather the data it creates …
Unspoiling the demo – Flashback Table and Flashback Query
The Whoops experience again. While preparing demos for OOW 2006, I did one update – or rather one commit – too many. I had assigned all employees to the …
Oracle Open World 2006 – Almost there…
It's almost Friday, a day before our flight. Lucas and I will be off to San Francisco on Saturday morning. Lucas will give some lectures on OOW 2006; I …
EJB 3.0 Java Persistence API – "Refresh After Insert": Using EntityListeners to absorb the effects from Database Triggers
While preparing an article for JDJ as well as a presentation for Oracle Open World next week, I finally got round to finding a proper solution for a challenge …
With double quotes (almost) everything goes…
After you have read the blog posts the websites of Sergio Leunissen, Eddie Awad or the "Ask Mr. Ed" website, you may wonder, if that was all you could …
Have MERGE remove records from Target that are not in the Source – Oracle 10g
The Oracle 10g Database release saw an extension of the MERGE statement with a DELETE clause. That by the way makes MERGE the only statement that can fire all …
Is this a bug in Analytical Functions? NULL is supposed to be UNEQUAL to NULL?
While presenting the 7Up Training – upgrading experienced Oracle developers from their Oracle 7 base of knowledge and experience ("still writing 7 backwards compatible code against a 10g database") …
OWB 10g R2Changing the repositories password disables the Control Center
If you change the password of the repository owner in Oracle Warehouse Builder 10g Release 2, the Control Center Service will fail to start. It is unusual that Oracle …