达梦：

CONNECT BY [NOCYCLE] < 连接条件> [ START WITH ] < 起始条件> |

START WITH < 起始条件> CONNECT BY [NOCYCLE] < 连接条件>

oracle:

select * from table [start with condition1] connect by [prior] id=parentid 

select * from table [start with condition1] connect by id= [prior] parentid

================》应该是一样的。