June 27, 2007

When to use ORDER in Sequences in PL/SQL

You may need to use ORDER to force sequence numbers to be output in the order of request when you’re using them for timestamping. Most of the time, your sequence

If You Build It, They Can Know

n a previous article I showed you how to leverage Semantic Web technology to create a relatively sophisticated sommelier application that recommended wines based on an understanding of wine styles.

Does Your RDBMS Support Savepoints?

Before using savepoints in your application, you need to be sure that your RDBMS supports this facility. To do this, call the DatabaseMetaData.supportsSavepoints method, like this: Connection conn=null;DatabaseMetaData dmd=null;…try{ dmd=conn.getMetaData();

Save a URL as an MHT File

To save a URL as an MHT file (Microsoft “Multipurpose Internet Mail Extension HTML”?a Web Archive File), reference the Microsoft ActiveX Data Objects 2.7 and Microsoft CDO libraries and use