(Edmon Begoli) For all interested in using SQL Developer with XML DB, here is the step-by-step ‘how-to’ for creation of XMLType columns using this free SQL tool by Oracle.
Other News
TechTip: Handling SQL Return Codes, Part I
(Sam Lennon) In a previous article, I demonstrated that treating SQLCOD as a two-value field, just like a native IO on/off indicator has some inherent dangers. In this article, I encourage you to use SQLSTT instead of SQLCOD and I provide a list of the SQLSTT values that commonly occur in busine
Using Ant to inspect Connection Properties in WSDL Files that are generated by Oracle SOA Suite Adapters
(Sjoerd Michels) Oracle SOA Suite comes with a collection of adapters that allow you to easily tap into a number of technologies from BPEL Processes or from ESB Services. Want to connect to a database, hook up to a queue or access your E-Business Suite: create an adapter for it with a WSDL interface
Program with XML for DB2, Part 3: Program with XML in the client
(Hardeep Singh) Learn how to extend the XML model in order to create rich clients using XML data transferred from your application server. Discover how to use Dynamic HTML (DHTML) to present the XML, XPath to navigate the XML and the Document Object Model (DOM) to modify and serialize the XML back t
Introduction to DB2 9 database recovery
(Amol D. Barsagade) A tried and tested backup and recovery strategy is essential in preventing data loss. A database can encounter any number of problems, including power interruptions, storage media failure, and application crashes. Each of these can result in a database failure and each failure re
Oracle 11g’s SQL Performance Analyzer
(Grégory Guillou) A lot of things have already been said about the Real Application Testing Option — from the price to the most interesting technical details — by Ken Jacobs, Arup Nanda, and even by me. Why add something? Because while Database Replay gets most people’s attention, Real Application T
You can never start preparing too soon
(Willie Favero) I’m talking about planning for your next DB2 for z/OS upgrade. With many of you already running DB2 Version 8 for z/OS, it’s time to start getting ready for DB2 9. Yup, I’m suggesting that you start preparing your DB2 Version 8 for that eventual upgrade to DB2 9. It doesn’t matter if
Lesson 3: Working with SQL Server
(Ben Forta) In this lesson, you’ll learn how to connect and log into SQL Server, how to issue SQL Server statements, and how to obtain information about databases and tables.
Create a Custom DataGridView Column
(Ken Getz) I tend to get random e-mail requests for programming help. I do the best I can to solve all the issues that come up, but generally refer random questions to the public newsgroups. If the question is really interesting, however, I can’t help myself from digging in. Recently, I got an e-mai
Structured Exception Handling in VB.NET
(Irina Medvinskaya) VB.NET improved a number of features compared to the legacy VB language. One of the most notable changes is the introduction of structured exception handling. Even though VB.NET still supports the On Error Goto type of error handling, it’s not a good idea to use it. Instead, you