Retrieving Data from Oracle Database using table in SQL
I created a local package in Enterprise Manager for SQL 7.0 to retrieve data
from an Oracle database based on a field in one of my tables in SQL. I can't
figure out what expression or script I should use to identify the field and
then search Oracle based on that field. I am able to connect to the database
and search oracle based on a value I give it in the query manager. But,
the table in SQL will be updated daily and the new values in the table will
need to be used to search Oracle and pull it into a new table in SQL. Any
help would be appreciated.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL