#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2003
    Location
    Hong Kong
    Posts
    41
    Rep Power
    12

    Building SQL Statement


    Dear,

    Is there any tools to build SQL Statements from Oracle Database?

    And then copy the statements from the tools and paste it on the access query to become passthrough query for use in Microsoft access which database have the table linked to the oracle database.


    Thanks for your big help,

    Raymond
    Real, Nice and Beautiful are my hungry for knowledges.
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    18
    Rep Power
    0
    Why don't you create an ODBC connection in Access? Import the tables you want and create the queries using Access.


    Another tool for creating queries is Oracle Discoverer.

IMN logo majestic logo threadwatch logo seochat tools logo