Let me tell why I need a temporary table although I don't know how to create and use one in Oracle 10.
Following is the table and its values :
PARENT_ID is a foreign key to ID and both are in the same table.
Say sTree Object has the values of the row belonging to 'User Services (ID =1)'
sTree.getChildren() will return rows that has ID=2 and ID=3.
So far so good.
But based on some condition(where or join condition) I will limit the number of rows of the above table and say it looks like the following :
should return rows that has only ID=2.
1) I need the hibernate <one-to-many> mapping to act on the result set.
2) If not the result set should be inserted in a temporary table and the hibernate <one-to-many> mapping should act on that table.
If neither of them can be done,please suggest me another solution.