user13050752 wrote:What a silly statement to make.
Actually this is neither SQL SERVER nor Oracle syntax. That curly braces used for 'RESPONDBYDATE' is actually EScape syntax. If it is supported in sql server, it should be supporten in oracle as well.
user13050752 wrote:The JDBC drivers are available seperately for install, from the download page...
Thanks for the information.
I would like to know if JDBC driver comes directly with ORacle 11g or 10g database. actually In our code JDBC escape syntax is used. One of the customers is having error like "missing expression" in oracle environment. that is due to escape syntax.Their database is 10g. So I suspect if Oracle JDBC drive is there or not in their environment.
Stew Ashton wrote:OP didn't mention that JDBC was being used. OP only mentioned that query is being run against oracle using escape syntax and it's not working, and is then expecting that Oracle should support escape syntax as he had it working in SQL Server. Yes, JDBC does support it (and is clearly being used in some way by their SQL Server stuff), but OP then goes on to suggest that if JDBC isn't installed as standard on Oracle, then installing it will make the application work... which clearly it won't, as it won't change the way oracle handles that syntax... the syntax would actually have to be diverted down the JDBC connectivity rather than the current application's connectivity method.
Billy and BluShadow,
It appears that this "escape syntax" is a JDBC standard, so it is reasonable to ask that JDBC drivers support it.
I was ready to jump to the conclusion that this was an SQL Server thing, but no. Rereading the original question, the OP did mention that.
BluShadow wrote:OP said "this is neither SQL SERVER nor Oracle syntax". I said the OP did mention that "this was [not] an SQL Server thing". Just trying to be fair.
OP didn't mention that JDBC was being used.
Billy Verreynne wrote:I fully agree, and I am making enemies in my company by defending that point of view.
People choose one product over another, not because of sameness, but because of differences. These differences equate to one product being better than the other in the mind of the consumer/user.