Oracle has decided to add Conditional Compilation to Oracle 10g Release 2. As Bryn Llewellyn states in his white paper Conditional Compilation in Oracle Database 10g Release 2: Unusually, but for very compelling reasons, the feature has been made available in patchsets of releases of Oracle Database earlier than the one that introduced the feature. It is […]
Read moreCategory Archives: PL/SQL
Recursive programming…
If you don’t know where to start your with your program, recursion might be an option. I am working on some (perhaps useless) package code to convert an integer into a boolean representation. When I am converting the integer, I don’t know where to start my conversion. If the integer is relatively small and I […]
Read moreA boolean property that’s really an integer…
In my previous post I have been writing about how you can mimic properties in a PL/SQL package. One of the ideas I wrote about was a boolean property that internally is an integer value. How can this be useful. If, for instance, you want to turn logging on and of during the program, wouldn’t […]
Read moreA different approach…
Steven Feuerstein has presented a new approach to the development workflow in his best practices presentation he held in The Netherlands last week. He did this presentation about three times for different audiences. I have seen his approach before and I think the idea is pretty good. Don’t know if and how we can use […]
Read moreAnsi SQL vs Oracle SQL
Today I was wondering about whether we should be using Ansi SQL instead of the 'normal' Oracle SQL. Ansi SQL has been supported in Oracle since version 9i, but since we are still developing applications on Oracle 8i we haven't really given it much thought until now. We are migrating our development database to Oracle9i […]
Read moreParameters in Oracle
Until today I was under the impression that parameters in PL/SQL were unrestricted in size. That is only partially correct. I was playing around with a simple script to swap two variables without introducing a temporary variable (I know, completely useless, but fun to think about a bit). I created the following package CREATE OR […]
Read moreOPP2007
After being in classes for two days I think OPP2007 was a big success. I have seen some (though not all) good speakers and they provided me with some nice ideas I can probably use in my future work. As soon as we upgrade most of the databases to a more recent version (we are […]
Read moreCode Tester…
According to Steven Feuerstein’s post on his ToadWorld Blog, CodeTester 1.5 will be available soon. It will not yet fullfill all your testing needs, but it’s a great start. I am one of the moderators of the utPLSQL project (and the creator of the forum used by the community) (also mentioned in the post), but I […]
Read moreAdding custom functions to Excel
If you are, like me, programming in different languages, maybe you have also noticed that you miss certain functions in a language, which are available in a different language. What I am used to do, is either find a function or functions that perform the same task: Delphi: Dec(i);PL/SQL: i := i – 1; or […]
Read moreTabs in output
By default, when you press the tab-key in the editor, the indent is replaced by spaces. I wanted the generated code to contain tabs instead of spaces, so I have created the following code: An Oracle Stored Function: create or replace function tab_char return varchar2 is begin return chr(9); end tab_char; In the cgml code […]
Read more