(Marin Komadina) Oracle has not solved the problem of exporting all but a few larger tables from a user schema thus far. This leaves DBAs to find their own workarounds when necessary. This article covers the three most used solutions. – Full export – Data dictionary view modification – Fine

This article demonstrates how to call an Oracle package to retrieve a recordset using ADO on Active Server Pages (ASP). This article assumes that: You are proficient with Visual Basic Scripting Edition (VBScript), ActiveX Data Objects (ADO), and Active Server Pages (ASP). You understand Oracle’s

(Barbara Darrow) Oracle says its upcoming database will do big things for mid-sized customers. A key goal Oracle10g, due by years’ end, is not only to bolster the company’s strong position in the enterprise but to out-maneuver Microsoft SQL server in smaller companies, said Andy Mendelsohn, seni

(Jonathan Gennick and Peter Linsley) Letters, numerals, and punctuation—all characters, in fact—are represented in a computer as numbers, and there are dozens of different schemes for encoding characters. As computer applications became more global, driving the need to support characters from la

Quintessence Systems, the only vendor providing 100% automated software technology for migrating Oracle legacy applications into Java, announced that its in2j migration tool has been extended to support the automated migration of Oracle business logic into Java code and DB2-compliant SQL ready for d

(Joris Evers) Lawyers for Oracle Corp. yesterday tried to persuade a California judge to reverse a “tentative ruling” to allow a PeopleSoft Inc. lawsuit against the company to move forward.

The Microsoft OLE DB Provider for Oracle provides access to Oracle databases. Using the Microsoft OLE DB Provider for Oracle, Microsoft SQL Server distributed queries can query data in Oracle databases.

(Jason Hunter) In “X Is for XQuery” (Oracle Magazine, May/June 2003), I introduced XQuery, a technology under development by the World Wide Web Consortium (W3C) intended for querying and manipulating XML data or anything that can have an XML facade, such as a relational database. That introductory a

(Joe Outlaw) Siebel is still the undisputed CRM-application market leader when it comes to functionality. But, as market demand shifts away from pure CRM enablement and toward business-process automation, vendors with broader application footprints — like Oracle, for example — are growing in popul

To use the Oracle bulk loader, you need a control file, which specifies how data should be loaded into the database; and a data file, which specifies what data should be loaded. You will learn how to create these files in turn.