AskTom down
I went to asktom.oracle.com this morning and I was greeted by the ORA-01688 error. Take a look: Continue reading…
HTML DB
For companies that are already on Oracle, Oracle HTML DB is shaping up to be a competitor to Macromedia ColdFusion and other rapid web development solutions. What is Oracle HTML DB? Continue reading…
1 Comment | Filed in ColdFusion, Oracle | Tags: application-expressSQL PLUS Gotcha
While reading the oracle-l mailing list, someone asked a question about (auto)commiting transactions in SQL Plus. Consider: Continue reading…
2 Comments | Filed in Oracle | Tags: gotcha, sqlplusTriggers and Constraints
I was reading Jeff Hunter’s problem about triggers and constraints with interest. Here is a summary of the problem: Continue reading…
Comments Off | Filed in Oracle | Tags: constraint, triggerOraBlogs Button
This weekend, while my son was sleeping at home and my wife was in the mall shopping (I hate shopping), I realized that I had some free time. So, I went ahead and created the following two buttons: Continue reading…
Comments Off | Filed in OracleTesting with IE7
As you may already know, I have been developing applications in Oracle and ColdFusion for a few years now, thus the theme of this blog. When developing quality web applications (using any technology) you have to test your application in as many browsers as you can. Most importantly, IE and Firefox. With IE7 just around the corner, how do you test your application against this Firefox contender without messing up your IE6 installation? Jon Galloway has the trick: Continue reading…
Comments Off | Filed in ColdFusion, Technology | Tags: internet-explorerBoredom kills
Are you bored at work? If you are, you are not alone. Continue reading…
Comments Off | Filed in Interesting StuffAdding IN parameter
Robert Baillie has posted a nice article reminding us about the use of “named notation” for program parameters, which triggered my memory about a problem I have had to deal with. I’m sure that some of you have encountered a situation when you needed to add an additional IN parameter to a program and use this new parameter in only one call. The other calls to this program did not need to pass any value to the new parameter. But if you added the new parameter to the program, you would break all the other calls. At the same time, you did not have the luxury to modify all the other calls. You were faced with a dilemma. Here is the solution, consider: Continue reading…
5 Comments | Filed in Oracle | Tags: pl/sqlORDER BY no order
If you want your result set ordered by something, you better use the ORDER BY clause. If you don’t, there is no guarantee that the rows from the query will be ordered in any way. Fine, you may already know that. But, what about if you want to make sure that the rows from a query are returned in no specific order, i.e. in a random order. Here is how you can do it: Continue reading…
ANY, SOME and ALL in Oracle
I recently stumbled upon a SQL query with ANY in the WHERE clause; it caught my attention because it reminded me of the rarely used SQL comparison operators ANY, SOME and ALL. Let’s play with these operators a little bit. But first, some definitions (from the Oracle Docs): Continue reading…
