Is there any such thing as ANSI Standard SQL ?
Lots of databases claim to conform to this standard. Recent experience tends to make me wonder whether it’s more a just basis for negotiation.
This view is partly the result of having to juggle SQL between three different SQL parsers in the Cloudera Hadoop infrastructure, each with their own “quirks”.
It’s worth remembering however, that SQL differs across established Relational Databases as well, as a recent question from Simon (Teradata virtuoso and Luton Town Season Ticket Holder) demonstrates :
Is there an Oracle equivalent of the Teradata LIKE ANY operator when you want to match against a list of patterns, for example :
like any ('%a%', '%b%')
In other words, can you do a string comparison, including wildcards, within a single predicate in Oracle SQL ?
The short answer is yes, but the syntax is a bit different…. Continue reading