Porting Oracle Database

Porting MS SQL 2000, sybase, MySQL and DB2 databases to Oracle 9i

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.

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.

» Request for Quote.

» Launch New Project.


Database Consulting
· Offshore Database Consulting
· Embedded Database Development

Case Studies
· Database programming


Data Warehouse Solutions

· Data Warehouse
· e-Business Intelligence
· Re-Engineering of DW applications
· CRM Data Warehouse
· Data Warehousing Implementation
· Data delivery applications
· Data integration

Case Studies
· Business Management System
· Data Warehouse WAP System
· Cell-phone Users Survey
· BI Platform Development
· Data Warehouse Reporting Portal