Hello, I have to write an SQL statement that is compatible with both
Oracle and MSDE. I'm somewhat of an SQL newbie, so please bear with me.
We are running into problems because || and CONCAT() are not supported on
MSDE. Perhaps the wildcard % might not work either, I gotta check. But
is there something in sql that will check whether I'm in oracle or msde
and then execute the appropriate statement. There's one constraint, has
to be a single SQL statement, and can't be a procedure or function, nor
can it be PL/SQL. I'm using a frontend application that requires this.
Hello, I have to write an SQL statement that is compatible with both
Oracle and MSDE. I'm somewhat of an SQL newbie, so please bear with me.
We are running into problems because || and CONCAT() are not supported on
MSDE. Perhaps the wildcard % might not work either, I gotta check. But
is there something in sql that will check whether I'm in oracle or msde
and then execute the appropriate statement. There's one constraint, has
to be a single SQL statement, and can't be a procedure or function, nor
can it be PL/SQL. I'm using a frontend application that requires this.