MySQL and SQL Server – Oracle CONNECT BY PRIOR for Recursive, Hierarchical Data
Recursive queries are something I have used many, many times over the years to build dynamic, n-tiered hierarchies. Oracle’s CONNECT BY PRIOR is awesome.
Does anyone know if this is possible in SQL Server or MySQL?
From what I understand, stored procedures would need to be used in MySQL and SQL Server to accomplish what Oracle does in one SQL statement with CONNECT BY PRIOR. I need to dig into the other databases a bit further to verify, but I am interested in any elegant solutions people have come up with if you would like to share.
Related Information:
- Staging Data with MySQL, CSVed, and XAMPP
The Task: Take and load,...
- Oracle Database vs Sun MySQL
Well, this is a topic...
- Oracle XE Limitations (CPU, RAM, Data Limits)
I was trying to make...
- Registering Oracle HTTP Server with Oracle WebLogic Server
For Fusion Middleware Control to...
- TOAD for Oracle 9 or TOAD 10 – 64-bit Windows – ORA-12154: could not resolve the connect identifier specified or ORA-6413: connection not open
I recently downloaded the new...
- Oracle Application Server Startup and Shutdown Script Generator – FREE
Complete the below to receive...
- Server Technologies
M&S Consulting has experience designing...
- Copy Table Columns and Data
As you may know, in...

Recent Comments