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 moreCategory Archives: PL/SQL
Raptor 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 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 moreFeuerstein blogging…
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.
Read moreSelection Information
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 […]
Read moreConstraints and Row Level Security
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 […]
Read more