Re: Equivalent of "start with...connect by" clause
Kapil Ranade Wrote:
-------------------------------------------------------
> 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
13863
October 30, 2008 11:26PM
Re: Equivalent of "start with...connect by" clause
5375
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.