(Scott Stephens) Many languages, including English, use accented characters. Since these characters aren’t part of the ASCII character set, it can be difficult to write code that uses these characters without looking up Unicode values or using a Unicode editor and converting to a known character set

(Mark Rittman) Once in a while, I read something about Oracle that stops me in my tracks and makes me really think about how I approach my job. Recent examples include starting to work with 9iAS, and slowly becoming aware of how much I’m going to have to get my head around the role Java and middlewa

(Scott Spendolini) Product manager Scott Spendolini explains why HTML DB is one of Oracle Database 10g’s hidden gems—and how it can save you substantial development time.

(Satyanarayana Josyula) You can reset the serial numbers after each group break using a single query–without using any utilities. This technique uses the ROWNUM returned by Oracle and resets the serial number at the beginning of each group. Also this query shows how to suppress the repeating gr

On the surface, it may appear that the SQL clauses IN and EXISTS are interchangeable. However, they’re quite different in how they handle NULL values and may give different results. The problem comes from the fact that, in an Oracle database, a NULL value means unknown, so any comparison or oper

(Bill Hamilton) Learn how to use ADO.NET 1.1 to retrieve data from complex Oracle data types.

(Barry Etter) This small VB.NET application allows you to compare Oracle database schemas against one another. This is very helpful when making sure your development instance is the same as your production instance; especially when implementing front-end changes.

(Matt Rohrer) As announced in July, Oracle has made the Oracle Database 10g Early Adopter Release for Mac OS X available for download. The following guide will help you set up a development workstation with the Oracle Database, PHP compiled with OCI support, and a more productive wrapper for SQL*Plu

(Steve Callan) Part one of this series covered some important aspects of Oracle administration (MetaLink and licensing). Part two highlights the Oracle PartnerNetwork (OPN) and Oracle sales/reselling. Most DBAs will not have occasion to work directly with either of these programs, even though they m

(Brian Barbash) Service-oriented architecture (SOA), while its underpinnings have been around for years, has recently become one of the most talked about topics in the IT industry. The interest in SOAs is largely due to the emergence of Web services and their ability to expose business applications