Forum OpenACS Q&A: Re: Help needed porting a PG query to Oracle

Collapse
Posted by Dave Bauer on
Silly me! You need to port to Oracle. I should read, or not post so early.

Here is a similar Oracle query from file-storage as well

select site_node.url(node_id)
from site_nodes
where object_id = (select r.package_id,
r.folder_id as root_folder_id
from fs_root_folders r,
(select item_id as folder_id
from cr_items
connect by prior parent_id = item_id
start with item_id = :folder_id) t
where r.folder_id = t.folder_id)