Home » RDBMS Server » Server Administration » Does ODBC translate Select statements with joins?
Does ODBC translate Select statements with joins? [message #375229] Tue, 07 August 2001 11:59 Go to next message
trixie keeper
Messages: 2
Registered: August 2001
Junior Member
Sorry to ask this question, but I'm a new programmer. I know that we can use ODBC driver to access heterogenous databases, my question is: If I create an sql statement using joins for MS access, will the ODBC driver translate it for ORACLE database?

Report message to a moderator

Re: Does ODBC translate Select statements with joins? [message #375231 is a reply to message #375229] Tue, 07 August 2001 12:51 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
yes, you can use same SQL to query oracle DB but it shouldn't contain any MS-access built-ins.(like translate,decode,to_char functions in Oracle)

Report message to a moderator

Previous Topic: Does ODBC translate Select statements with joins?
Next Topic: installation of oracle 8.1.7
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jul 05 11:12:47 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.