MySQL Forums
Forum List  »  Oracle

Re: Equivalent of "start with...connect by" clause
Posted by: Kyeongsu Bae
Date: April 29, 2009 02:36AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Equivalent of "start with...connect by" clause
4990
April 29, 2009 02:36AM


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.