Re: START WITH, CONNECT BY Compatibility

ashley wrote:
> Apart from Oracle, which databases support the "start with" and
"connect by"
> clauses for hierarchical query? Does MySQL and MSSQL support them?
Are
> their syntax portable with Oracle? I just need to evaluate this
before
> using these clauses in my oracle application - for portability
concern.

Suggestion:

when designing for db portability, do NOT restrict yourself to functionality that works on *ALL* databases: you'll find it is indeed very limited and you are shooting yourself in the foot by doing so. You are not designing-in portability, you are just brain-damaging your app.

Instead, code a module interface for the funtionality you NEED. *Then*, implement it for *EACH* platform db you want to use, using the appropriate functionality of *EACH* platform.

And if the database you are interfacing with simply cannot cope with the functionality you need no matter what, then seriously consider letting the developers of that database know that you will NOT port to their product: 9 times out of 10, you'll end up with that functionality supported and your work reduced.

As well as overall a much better implementation of YOUR app. Received on Sun May 22 2005 - 19:46:14 CDT