Shulou(Shulou.com)06/01 Report--

After reading a lot of blogs, it is said that the start with connect by statement of oracle is also applicable in HANA, but I reported an error when I executed the start with statement in hana studio, prompting: incorrect syntax near "START". Is there a solution?

The following is the original sql:

SELECT

SYS_CONNECT_BY_PATH (NAME,' |')

FROM

NC65.BD_CUSTCLASS

WHERE

PK_CUSTCLASS = CS.PK_CUSTCLASS START WITH PARENT_ID='~' CONNECT BY PRIOR PK_CUSTCLASS = PARENT_ID

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.