Regarding Syntax features in ANSI -SQL

[manickam]

Hi!

1. I want to know if 'START WITH' and 'CONNECT BY' syntax are available in ANSI SQL.(for SELECT query) as it is not possible to implement non-ANSI SQL atatements in JDBC.
If the syntax does not exist, can you suggest an alternative(without using stored procedures)?

(The query is :
SELECT FROM OrgUnitsMaster
START WITH OrgUnitCode=’xxx’
CONNECT BY PRIOR OrgUnitCode=Parent
This will return all OrgUnitCodes whose FirstLevelParent=xxx.)


2. I also want to know whether other major RDBMS platforms(such as MS SQL server, DB2) support such type of queries?

Thank you.

 

[sem]

You may use connect by clause with JDBC at least against Oracle database.