Progress
DataServer
for ORACLE Guide


SQL and Progress Queries

The DataServer allows you to use different approaches for querying an ORACLE database. Your application might be able to take advantage of their strengths depending on the kind of query you are writing and the kind of data you are accessing. The approaches are:

Another factor to keep in mind when deciding which technique to use for issuing queries is whether a query is better served by being processed by the client or the server. A Progress 4GL query is processed by the client (except in the cases of most joins), and SQL SELECT statements or PL/SQL statements are processed by the server (the ORACLE DBMS).


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095