(Christophe Marcel) CopySchema is a utility for copying all the data from one Oracle schema to another. Although similar to the exp/imp and bulk load utilities of Oracle, it has the advantage of offering a simple GUI interface and of handling changes to the schema. For example, if you are copyin
Other News
XML needs tools to take over the world
(Peter Abrahams) In previous articles I have written about why XML will take over the world and I have no doubt that the trend will continue. The benefits to business and to IT are compelling, XML helps create more agile enterprises, brings business and IT closer together and makes everyone more pro
Resolving the Unknown: Building Custom XmlResolvers in the .NET Framework
(Mark Fussell) This article gets under the hood of the XmlResolver class in System.Xml and describes how to create your own implementations of XmlResolvers that allow you to retrieve XML documents from alternative data sources, such as embedded assembly resources or from a database using custom defi
Validating User Input – An Introduction
(Scott) Data validation is an important task in any application. Before accepting new information from a user, you need to make sure all the information is present in required fields, make sure all the dates have a valid format, make sure all the numbers in a form have a valid range, and all the oth
Component to access databases in the .NET environment
(Xiangyang Liu) An extremely flexible and easy-to-use library that retrieves data in XML format, supports simple parameterized queries, stored procedures, and transactions. It can also be used as a web service.
Excel Document Management with the Oracle iFS (Internet File System)
(Marin Komadina) There are several methods to load data from Excel to Oracle and vice versa. Some of the methods are widely used while others are complicated and very seldom used.
Fast Path to IBM DB2 Universal Database in a Visual Basic .NET Environment
This course provides training using Microsoft Visual Basic .NET as an add-in with DB2 UDB V8 on Linux, Unix, and Windows. Learn how to use the Microsoft Development Environment to create DB2 UDB database applications. Design applications to create database objects, populate tables, execute queries,
In XML: Using SQL to Link Below the Root – Part 1
(Michael M. David) SQL/XML integration is in a mess today. Every SQL vendor’s XML support is proprietary and still does not integrate seamlessly, fully, or satisfactorily. The current working standards solutions, XQuery (when used in SQL) and the SQL/XML Standard are very XML centric and do not inte
Work with IBM DB2 UDB databases and SQL in Delphi for .NET
(Bob Swart) This article, a follow-up to the SQL DDL article, Using Delphi code to create/drop DB2 UDB database tables, focuses on the use of SQL queries to build simple and more complex SQL SELECT queries to end up with master-detail relations. The author also examines SQL joins in detail, covering
Cursors with SQL 2000 Part 1
(Don Schlichting) SQL languages are designed so groups of records, or sets, can be manipulated easily and quickly. The speed at which groups of data can be altered, updated and deleted, demonstrates why working with sets is the preferred method. A traditional programmatic database connection, us