Author
Topic: Different SQL formats (Read 822 times)

Does anyone have a reference that shows the differences between SQL syntaxes in various databases EA uses? Particularly I'm looking for differences between PostgreSQL and Oracle (though other xrefs are also nice to know).

I haven't really found a good reference, but I do have some translation functions in my framework that might be helpful.The are not complete, they only treat the thing I had to deal with.Here's what I have in my framework

Any casting, function calls, data extraction etc is going to require unique code for almost every database

Keep an eye out for the keywords for different databases. (If calling through EA, wrap the potential keyword in square brackets and let EA handle it)

In EA at least I always use the case sensitive table and column names. Oracle will return the columns in upper case, Postgres will return them in lower case. (Or something does...) Other databases are case sensitive in lookup of the table names, column names or both.