Pessoal, como fazer o seguinte Insert usando Hibernate:
INSERT INTO PROFILE_SECURITY
(ID_PROFILE,CODIGO_MENU)
(SELECT :1, M.CODIGO
FROM MENU M
WHERE NOT EXISTS (SELECT S.ROWID FROM PROFILE_SECURITY S
WHERE S.ID_PROFILE = : Profile
AND S.CODIGO_MENU = M.CODIGO)
CONNECT BY PRIOR PAI = CODIGO START WITH CODIGO = : Codigo)
Valew.