Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: check if oracle or MSDE
seannakasone_at_yahoo.com wrote:
> Is there a way to write a single SQL statement that will run a
> statement if you are in Oracle and run another statement if you are in
> MSDE? It has to be a single SQL statement because I'm using a front
> end application that requires that, so it can't be an PL/SQL script,
> proc, nor a function. Our application runs with either Oracle or MSDE
> so that's why i have this need.
>
No there isn't. This is however an application written in some form of
programming language no? If so then use the programming language
appropriately to do this task. It has to establish a connection to the
db, so it pretty much has to know what database it is talking to.
-- Niall Litchfield Oracle DBA http://www.orawin.info/servicesReceived on Tue Oct 02 2007 - 10:20:28 CDT
![]() |
![]() |