Feuerstein blogging…

Posted on January 17, 2006 by Patch72

Through an email I received from Steven today in his Feuerthoughts mailing (subscribe here) I noticed that Steven is also blogging. You can find his blog here or use the feed in your aggregator.

Selection Information

Posted on January 13, 2006 by Patch72

I came up with a new plug-in yesterday, inspired by the Scale… plugin by Scott Mattes. The problem I found with this plug-in was that it didn’t reuse the window. I primarily used this plug-in to find out the length of a selection in pl/sql developer. Maybe, when I have new ideas, I will […]

ANT 2.0 (2)

Posted on January 11, 2006 by Patch72

I just got the demo for the mouse hook I downloaded from about.com to work. This might be a good thing to use to implement the autohide functionality of the new ANT application. Nice to play with Delphi and Windows messaging again… 😉 And I found another link with explanation on how to hook the […]

ANT 2.0

Posted on January 10, 2006 by Patch72

First there was YALM (Yet Another Launcher Manager). Then I rewrote that application into ANT (ANother Toolbar). Now I came up with the idea to build ANT 2.0 and then blog some about it. I don’t know when I have the time to do this (it will be a really slow project), but I will […]

Old application, still running…

Posted on January 9, 2006 by Patch72

I just picked up an old application I wrote back in 1995. It has been written in FoxPro and it is still working. This might be a nice application to port to WindowsXP with an Oracle backend. One day. When I have some more time on my hands ;-). For now, the application does what […]

Constraints and Row Level Security

Posted on January 6, 2006 by Patch72

When you apply Row Level Security to a table, which has constraints, like a primary key or a unique constraint, then these constraints are evealuated regardless of the RLS policy. Of course this makes sense, especially in the case of a primary key, but it can be a problem with a unique constraint. If you […]

Column order

Posted on January 5, 2006 by Patch72

Yesterday I came across a rather strange problem, which was luckily relatively easily solved. The problem is like this: I am using QDA (Qnxo Development Architecture) packages to get to the data in my tables. In the Query Package there is a function to retrieve a row from the table. I had generated this code and […]

Shrinking tablespaces

Posted on January 4, 2006 by Patch72

As you might know, Oracle uses tablespaces to store the tables and the data within them. If you drop tables and/or users, the tablespace is not automagically shrunk to it’s minimal size. While playing around with my local database, I imported a lot of (big) tables. I wanted to reload a schema, but before I […]

Simple comparison SQL

Posted on January 3, 2006 by Patch72

I am comparing tables in two different schemas. Since I am doing the same thing over and over again I created a small script which might be useful to you too. ACCEPT db1 CHAR prompt ‘owner 1 :’ ACCEPT db2 CHAR prompt ‘owner 2 :’ ACCEPT tabname CHAR prompt ‘tablename :’ PROMPT PROMPT &db1..&tabname minus […]

Fun to watch