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
Other News
Learning Oracle PL/SQL? Here’s What to Expect
by Bill Pribyl – To help prepare a newcomer into the world of PL/SQL, I have collected some thoughts about the way that most new users seem to react to the language.
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,
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
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
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
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.
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
Using CSS2 to display XML documents
Outside of custom editors and viewers, reading XML data is comparatively difficult. A lightweight approach for viewing XML is to attach a cascading style sheet (CSS2) to XML documents and then use a recent Web browser to view them (Mozilla is excellent, IE often adequate). developerWorks columnist D
ebXML: Global Standard for Electronic Business?
After examining the basic blocks with Universal Business Language and XML Common Business Language, what else is missing for electronic business? A whole lot more is incorporated into Electronic Business XML, ebXML for short.