[rpmartin]

Does the ODBC driver support connect by queries for hierarchical data? I’ve been playing around with some and I’m not sure if they’re not supported or if I’m just not doing it right. The queries I’m trying look something like:

select website_department_name, website_department_id

from website_department

connect by prior website_department_id = parent_id

which produces the oh-so-explanatory ‘Error: Syntax Error in the SQL statement.’

Thanks in advance,

Rob
This is a cached copy. Click here to see the original post.

[ivan.parra]

RE: ‘Connect By’ queries

Connect by is not supported.

[Author]

Posts