Oracle 8.0 SQL query using OLE DB Provider for Oracle

This is a discussion on Oracle 8.0 SQL query using OLE DB Provider for Oracle within the ODBC forums in Framework and Interface Programming category; Hi, I'm trying to optimize a complex join (9 tables), which I perform as a single SQL statement. I thought I could use a view, but don't know how to perform more than one statement at a time as an OleDbSelectCommand.CommandText How does one go about executing multiple statements from VB?...

Go Back   Application Development Forum > Framework and Interface Programming > ODBC

Object Mix

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 01-09-2004, 06:57 PM
Richard Adams
Guest
 
Default Oracle 8.0 SQL query using OLE DB Provider for Oracle

Hi, I'm trying to optimize a complex join (9 tables), which I perform
as a single SQL statement. I thought I could use a view, but don't
know how to perform more than one statement at a time as an
OleDbSelectCommand.CommandText

How does one go about executing multiple statements from VB?
Reply With Quote
Reply


Thread Tools
Display Modes


All times are GMT -5. The time now is 07:10 AM.


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
vB Ad Management by =RedTyger=

In an effort to better serve ads to our visitors, cookies are used on objectmix.com. For more information, check out our Privacy Policy.