By Karen Porter – I have often needed to find a value held within a table when I don’t know what table or column_name would hold the value. For example, I recently needed to determine if an incorrect domain name had been populated into the database, but with Oracle’s tools, I wasn’t sure where the v
Author: SSWUG Research
The Euro-Savvy Database
By Gilles Briard – Oracle has made sure to adhere closely to ISO (International Standards Organization) standards regarding the Euro character, so Oracle customers can rest assured that database versions released since the standards were set (8.1 and above) can handle the Euro character properly. Ho
Compiling the paths and automating tests
By Benoit Marchal – Work on HC, the SAX ContentHandler compiler, continues. This month, our columnist discusses the compilation algorithm. He also invests a bit of time automating tests with JUnit.
Populating an HTML Template with XML Data
By Yehuda Shiran – To convert an XML file to HTML, you start by writing the skeleton of the HTML file, specifying all tags such as <BODY> and <H1>. The content between each pair of tags is selected by XML directives. Take a look at the following line:
Top Ten Oracle JDBC Tips
by Donald Bales – The Java Database Connectivity (JDBC) API is a set of interfaces that allow a Java programmer to access a database. The interfaces are implemented by each vendor’s set of implementation classes. After several years of working with Oracle’s JDBC implementation, I’ve learned a number
Bunch of Fives: 5 database stories you really should read
From SeachDatabase.com – IT-Director has put together a top five list of database stories from 2001. They include Larry Ellison’s offer to be your mailman, Oracle’s dissing of DB2, and Sybase’s optimistic view of its future.
Oracle Launches New Oracle9i Certifications
The new Oracle Certification Program for Oracle9i offers three distinct certification tiers that are built to fit the needs of both IT professionals as well as the organizations they serve. Each tier constitutes a benchmark of expertise that is industry-recognized and approved as applicable for spec
How XML could bring an end to all of your troubles
Where have you seen or heard this before? "We have the solution to all your problems." My inbox and voice mail are full of these. The most recent truckload came in response to my column about how Samsung and Oracle have replacements for Microsoft Exchange.The more I thought about the
Using Python and XML with Microsoft .NET My Services
by Christopher A. Jones – What many developers realized after viewing the beta code, presentations, and samples is that Microsoft has indeed been focusing on the nature of these XML-based Web services and their utility, and they've created a series of services with an infrastructure fabric under
N:N relationships with DBMS_XMLQuery Package
By Pedro Gil – With all the samples I provided earlier I've been giving a simple query to be output into XML, but in a real life situation the xml files are much more complex than this, perhaps you will have to deal with N:N relationships. Let's suppose the following database schema,