DBAzine.com

Sections

Personal tools

You are not logged in
Log in
Join

You are here: Home » Oracle » Oracle Articles Archive » Parsing in SQL » Recursion

Seeking new owner for this high-traffic DBAzine.com site.
Tap into the potential of this DBA community to expand your business! Interested? Contact us today.

Who Are You?

I am a:
[ Results | Polls ]
Votes : 3554

Comment

Above in this comment thread: Parsing in SQL

Recursion

Posted by laurentschneider at 2006-12-13 03:49 AM

Why did you mean Oracle did not implement recursion ?
http://download-west.oracle.com/docs/cd/A87860_01/doc/appdev.817/a77069/07_subs.htm#1198

recursion in SQL

Posted by mikharakiri at 2006-12-21 04:49 PM

In the context of SQL the recursion is understood to be recursive query:

with TC as (
select head, tail from Edges
union
select e.head, tc.tail from Edges e, TC tc
where e.tail = tc.head
) select * from TC

Transaction Management
Reduce downtime and increase repeat sales by improving end-user experience.
Free White Paper

Database Recovery
Feeling the increased demands on data protection and storage requirements?
Download Free Report!