transfer Access-Queries to Oracle

[wichtel]

Hi,

I'd like to transfer access-queries to Oracle. If I export access-queries, Oracle recognize these as tables and not as dynamic queries? Any idea how to solve this or does anybody know a tool to create queris in Oracle?

Thank!
Tom

 

[Pat Hartman]

I think the Oracle equivalent of an Access querydef is a view if that helps you. Access' SQL is slightly different from Oracle's SQL so you will probably have changes to make anyway.

 

[RV]

You run queries on ORACLE, you don't store them in your ORACLE database.
ORACLE is a real relational database, basically it holds the database tables, no more.

You create queries on ORACLE instances using tools such as SQL*Plus or TOAD.

Take into account that Access' SQL is rather different from Oracle's SQL.
Meaning, the structure is basically the same, but functions are quite different.

RV