Jacob Kaplan-Moss wrote:
Off the top of my head, the big difference I can think of is that Oracle doesn't support LIMIT/OFFSET on queries (you're supposed to use a cursor or a temp table).
Oracle has 'rownum' - a virtual field representing the ordinal number of a row. So you can do this:
SELECT id, name FROM table where rownum<=5;
This in and of itself causes issues for Django, and I'm 99% sure there are other differences of this type.
My experience is that Oracle mostly differs by features not present in other systems, not the contrary :-)
