July 3, 2007

Using ANYDATA in Oracle 9i

First introduced in Oracle 9i, ANYDATA is a “self-describing data instance type” which means it not only holds the value, but it also holds its own data type within each

In-memory JDBC Driver Details

When you’re working with JDBC, you can load more than one JDBC driver in memory. To find out how many drivers are in memory, along with other useful driver information,

Determine Whether a URL Is Valid

Use this Boolean function to determine whether a URL is valid: public static bool checkUrl(string url) { bool rt = false; if (url.StartsWith(“www.”)) { url = “http://” + url; }

SQLCLR Security and Designing for Reuse

n important principal of software design is that of “least privilege.” Basically, in any given layer of a program, you should grant only minimal access such that the code has