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 numbers will be in order anyway. If you are using exclusive mode, for example, Oracle always generates sequence numbers in

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. The application’s understanding of wine was based on a model?a pre-existing ontology of wines and their relationships. As you may

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(); if(dmd.supportsSavepoints()) System.out.println(TRUE); else System.out.println(FALSE); }catch(SQLException e) {System.out.println(e.getMessage());} … Note: This tip applies to JDBC 3.0 and higher drivers.

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 the following code: void SaveWebPageToMHTFile( string url, string filePath){ CDO.Message msg = new CDO.MessageClass(); ADODB.Stream stm = null ; msg.MimeFormatted