Skip Headers

Oracle9i Application Developer's Guide - Fundamentals
Release 2 (9.2)

Part Number A96590-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to next page

19
Porting Non-Oracle Applications to Oracle9i

Often, a programming project requires adapting existing code rather than writing new code. When that code comes from some other database platform, it is important to understand the Oracle features that are designed to make porting easy.

Topics include the following:

Frequently Asked Questions About Porting

How Do I Perform Natural Joins and Inner Joins?

When porting queries from other database systems to Oracle, you might have needed in the past to translate ANSI join notation into Oracle's comma notation.

You can now code Oracle queries using ANSI-compliant notation for joins. For example:

SELECT * FROM a NATURAL JOIN b;
SELECT * FROM a JOIN b USING (c1);
SELECT * FROM a JOIN b USING (c1) WHERE c2 > 100;
SELECT * FROM a NATURAL JOIN b INNER JOIN c;

The standard notation makes the relations between the tables explicit, and saves you from coding equality tests for join conditions in the WHERE clause. Support for full outer joins also eliminates the need for complex workarounds to do those queries.

Because different vendors support varying amounts of standard join syntax, and some vendors introduce their own syntax extensions, you might still need to rewrite some join queries.

See Oracle9i SQL Reference for full syntax of the SELECT statement and the support for join notation.

Is There an Automated Way to Migrate a Schema and Associated Data from Another Database System?

Yes. Oracle provides a free product called the Oracle Migration Workbench that can convert a schema (including data, triggers, and stored procedures) from other database products to Oracle8 and Oracle8i. Although the product itself runs on Windows, it can transfer data from databases on other operating systems, to Oracle databases running on any operating systems.

By using this product, you can avoid having to write your own applications to convert your legacy data when switching to Oracle8i. Related technology lets you convert certain kinds of source code, for example to migrate Visual Basic code to Java.

At the time of this publication, migration is supported from the following databases:

For the current set of supported databases, see the Web site:

http://otn.oracle.com/tech/migration/

How Do I Perform Large Numbers of Comparisons within a Query?

When you want to choose from many different conditions within a query, you can use:

The CASE technique is more portable, and is preferable for new code.

Does Oracle Support Scalar Subqueries?

Oracle9i does support scalar subqueries.


Go to previous page Go to next page
Oracle
Copyright © 1996, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback