Equivalent of "start with...connect by" clause
What is mysql equivalent of "start with...connect by" clause of oracle?
I have following query:
"select lpad('-' ,6*(level-1))||unit_name as UNIT_NAME, UNIT_ID ,UNIT_LEVEL
from unit WHERE UNIT_ORG_LEVEL != (select max(unit_org_level) from unit )
start with Unit_id = '" + value_from_some_variable + "' connect by prior unit_id = parent_unit_id";
Please help me with this.
Subject
Views
Written By
Posted
Equivalent of "start with...connect by" clause
13850
October 30, 2008 11:26PM
5373
April 29, 2009 02:36AM
5278
May 07, 2009 01:44AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.