There are no 10g features used in these queries. SYS_CONNECT_BY_PATH and the WITH clause are the two most recent features and both should be in your 9.2 database.

Can you show the SQL that you are trying to execute and that does not work? By the way: if you run the SQL directly in SQL*Plus, does it then fail too?

best regards,

Lucas

]]>By: Donna Oliverhttps://technology.amis.nl/2005/08/11/selecting-a-pruned-tree-with-selected-nodes-and-all-their-ancestors-hierarchical-sql-queries-and-bottom-up-trees/#comment-2296
Wed, 28 Jun 2006 18:35:38 +0000/?p=701#comment-2296We are currently running forms 6.0 (c/s) on an Oracle 9.2. I’m trying to “prune” a tree but can’t get it to work right. Is the above logic only available with 10?