Due to SoftTeco’s active involvement in the professional growth of employees, we continue to highlight interesting events connected with specialists’ development. Not long ago, one of SoftTeco’s developers took part in the famous annual training session, Java Bootcamp. The event took place in Saint Petersburg from the 2nd to 14th of February. Java Bootcamp is a unique experience in the CIS region where beginners and skilled developers can boost their knowledge of Java. Organizers create perfect conditions for participants to…
Today I’ve decided to get rid of the Windows virtual where Oracle XE 10 and to move data to Oracle XE installed on my Fedora host. Everything seemed to migrate correctly using imp/exp utilities. After I ran the appllication server and tested it a bit, I’ve ran into the problem with the hierarchical queries. I’m trying to run the query like:
SELECT sys_connect_by_path(ent.STATE,'//') as state
FROM E1 element LEFT JOIN E2 ent ON element.id = ent.id
WHERE CONNECT_BY_ISLEAF = 1
START WITH element.ID = 'Test'
CONNECT BY NOCYCLE PRIOR element.id = element.PARENT_ELEMENT_ID
This query now fails with the error: ORA-30004: when using SYS_CONNECT_BY_PATH function, cannot have seperator as part of…