Toad Extension for Eclipse version 1.6.5 contains many enhancements. One of the most useful improvement is related to management of documents stored in BLOBs. Now it is possible to view documents - open them in Eclipse or associated external application, export the content to external file, import a document to the selected BLOB field or just set the value to null.

In one important respect, writing software is no different from driving a car. You can be the best driver in the world, but if the other driver is awful, you can still have a big problem on your hands. So you drive defensively; you stay alert to the possibility that another driver might make a poor decision or be careless. You protect yourself as best you can.

It’s the same with software. You believe that you are a fine programmer (and I have no reason to doubt that!), and that your programs work well. But have you guarded your programs against people who might use them carelessly or in ignorance? Probably not.

The usage and implementation of web applications with DB2 z/OS as the backend for data is growing. New applications have been developed on distributed platforms. They use interfaces to connect to DB2, which only support dynamic SQL statements like JDBC (for Java) or CLI/ODBC (for C, C++, C# programs).

Furthermore, ERP/CRM solutions like SAP or Siebel also work with dynamic SQL statements. Those applications allow their...

Since version 8.7, our Quest SQL Optimizer has been enhanced to support Exadata. These enhancements focus on displaying smart scan and bloom filtering on both the original query plan and alternative plans.

I have been researching new rules exclusively for Exadata and have found that there are not many discussions on SQL tuning on an Exadata machine. We also have not spent a lot of effort on SQL transformation. With...

Problem: Jasper queries the same, unchanging data over and over and over again.  What's the solution?

Sure, you should certainly read my blog - and encourage everyone you know to do the same.

But there are lots of other fantastic Oracle technologists out there, and several write blogs on Toad World.



So today I would like to start the New Year by drawing your attention to the excellent writing of Dan Clamage. I've known Dan for years, since 1997 in fact (just searched my email history). He's reviewed...

A segment is any object that requires storage in a tablespace – tables, indexes and Lobs (Large-Object Binary) come to mind. You can see what segments are in your schema by querying the appropriate Data Dictionary view.