Hello,
Hibernate version: 3.3
Name and version of the database you are using: Oracle 10G
Is it possible with Hibernate to create an "Inline view" written under Oracle 10G . For instance this query :
Code:
SELECT *
FROM trs_dossiers_v table1,
(SELECT pos_dsr_id
FROM lgi_comment_t com, lgi_post_t POST
WHERE com_pos_id = pos_id AND com.com_comment LIKE '%test%') commentaires,
(SELECT pos_dsr_id
FROM lgi_term_t trm, lgi_post_t POST
WHERE trm_pos_id = pos_id AND POST.pos_subject LIKE '%test%') terms
WHERE table1.requester_id IN (3232)
AND table1.YEAR IN (2005, 2006, 2007, 2008)
AND terms.pos_dsr_id = table1.ID
AND commentaires.pos_dsr_id = table1.ID
If yes, how can I do it ?
If no, why ?
Thanks by advance,
Regards,
Eric
Login
FAQ
Search