MySQL and SQL Server - Oracle CONNECT BY PRIOR for Recursive, Hierarchical Data

By M&S Consulting (Ashok) on Feb 24th, 2010
Filed Under Technical Tips // Tags: , ,

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.

Bookmark and Share

Related Information:

  1. Oracle Database vs Sun MySQL
    Well, this is a topic we have reviewed numerous times over the years for projects and customers. The fact is,...
  2. Staging Data with MySQL, CSVed, and XAMPP
    The Task: Take and load, using MySQL, a flatfile of over 450 colums and over 145,000 rows of data and...
  3. 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 10.x version of TOAD and could not connect to my databases. Still running TOAD 9.x,...
  4. Google Apps Reporting API - Not quite this easy with Exchange
    I have been somewhat enamored by Google Apps and its potential. Many enterprises have been happy with Exchange for mail,...
  5. Oracle Application Server Startup and Shutdown Script Generator - FREE
    Complete the below to receive scripts to automatically startup and shutdown your Oracle Application Server 10.1.2.x or 10.1.3.x midtier environment....
  6. Oracle IdM - SAML SSO with Google Apps
    We recently integrated Oracle IdM with the SAML SSO Service from Google Apps. Now customers can continue to authenticate against...

Leave a Reply


Archives

Recent Comments

  • Kavitha Muniraj said: Hi, Could you please send a script which checks the status of forms and reports of oracle...
  • Siddharth said: Hey thanks a lot !! Have been lookin all over for this :) My PC may not be able t handle FlashBuilder...
  • Cyrex said: Hey man why I cant install Apex 4? is there anyone can help me.,?
  • sharanabasava said: ALTER TABLE [my_table_name] RENAME COLUMN [current_column_name] TO [new_column_name]; Sir,I...
  • Huub Vankan said: Thanks for this easy solution. Indeed strange that is does not work in the (x86) folder….

Calendar

July 2010
M T W T F S S
« Jun    
 1234
567891011
12131415161718
19202122232425
262728293031  

Featured Testimonial

"M&S has taken 'partnership' to a new level. They are not only a deeply skilled service provider, the M&S team is actually a mission critical component to our operations, taking on new initiatives as well as maintaining custom, open source, and COTS solutions."

CEO, MedPivot

Free SQL Service