I found a message on the PL/SQL Developer forum which requested a plug-in to change the selected text to InitCaps. I decided I could build this plug-in, so I did. You can find this plug-in on this site.
Read moreRaptor renamed
In one of my previous posts (actually my first post on this blog) I wrote about project Raptor. I think they are almost done with development since they seem to have changed the name to SQL Developer (via). The name can be easily confused with PL/SQL Developer. Maybe that’s just the idea. To get more hits on this product […]
Read moreHandy date functions…
I came across the need to define the first day of next month based on the current systemdate. I can do this using the following code: add_months(to_date(’01’||to_char(sysdate,’MMYYYY’),’DDMMYYYY’),1) But the I remembered that there was a post on the oracledeveloper.nl forum with similar date functions. First day of the week: select trunc(sysdate,’IW’) the_date from dual; First day […]
Read moreKeep Alive
Keep Alive is a tool to prevent the screen saver from kicking in. Especially useful when you are watching a DVD on your computer. I have enhanced this tool to enable you to choose the screensaver from the tool. That is especially useful when your sysadmin has disabled the screensaver tab with a policy. I […]
Read moreGlyphs on buttons
In a previous post I wrote about the idea of storing the glyph in the TCollectionItem and then show this on the button, but after some more thought I came to the conclusion that this would mean that I would have to change the entire way the TToolbar works. The TToolbar stores the images in a […]
Read morecomments (2)
Often, I find myself commenting out chuncks of code. Either because I decide to go on a different route with the solution, or because the specs for the program change (do they change? YES). When revisiting the code after a while, I sometimes don’t seem to be able to come up with the why of […]
Read moreComments
If you want to temporarily disable your code you normally comment this piece out. I generally use either — (line comment) or /* */ (block comment). The code below: SELECT * FROM emp WHERE 1=1 AND empno < 1000 becomes either: --SELECT * -- FROM emp -- WHERE 1=1 -- AND empno < 1000 or: […]
Read morePronunciation
Eddie Awad has a couple of nice posts on his blog on how to pronounce the terms used in PL/SQL. The first one is Char or Car? The second one is see-quel wins, but what about the others? On the second one he has a poll on pronunciation of a couple of terms. The nicest […]
Read moreRegular Expressions in 10G
Today, I came across an article on how to Develop and Test Regular Expressions with a Unit Testing Package. I know just a little bit about Regular Expressions but I know that they are really powerful. I have used some (simple) form of them to find (and replace) stuff in Delphi files, mostly the .dfm […]
Read moreRecords in Delphi
In Delphi, you still have the old pascal method of creating records to hold data and then create pointers to get to this data. The problem with this approach is that it is not really object oriented. You have to cleanup the records behind the pointers. There is no way Delphi can do this for […]
Read more