5 ms·
Yes that's true. But please consider that some orgs prefer self hosting their software. In this case using their database would be preferable.
by spapas82 4y ago
Yes that's true. But please consider that some orgs prefer self hosting their software. In this case using their database would be preferable.
- vulcan01 4y agoIn that case, only using ANSI SQL will help (i.e. no vendor-specific queries).
- rst 4y agoUnfortunately, you can't count on the enterprise's pre-existing DB to support all of ANSI SQL well. Oracle in particular deviates from ANSI in a whole bunch of well-known ways (messed-up date types, treating the empty string, '', as the same thing as NULL, etc., etc.), which are almost certain to trip up SQL which hasn't been tested against it.