I want to be able to use the connect by prior and LEVEL in my sql statement.
Is this possible in CMP (1.0)
I am using JBOSS 2.4.4
I think it isn't but just wanted to ask.
Thanks
Ron
select T$MITM, T$SITM,LEVEL from baan.ttisfc954001 where T$CPRJ='219657'
and T$ADDN=2
start with T$MITM=' INJECTION'
connect by prior T$SITM=T$MITM ;