DBAzine.com

Sections

Home
Of Interest
Data Warehouse
DB2
Oracle
SQL Server

Personal tools

You are not logged in
Log in
Join

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

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 : 3553

Comment

Above in this comment thread: Parsing in SQL » Recursion

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!