>>Can you explain how?

I do not study your topic much and i can be wrong here. But maybe you got the idea about what i am thinking about.

SELECT

                (SELECT

                               PRE.ITEM_CONTENT_ID

                FROM

                               FISHEYE_GALLERY_IMAGE_MAP PRE

                WHERE

                               PRE.GALLERY_CONTENT_ID = :parent_id

                               AND PRE.ITEM_POSITION < FGIM.ITEM_POSITION

                ORDER BY

                               PRE.ITEM_POSITION DESC ROWS 1) AS PRE_ITEM_CONTENT_ID

                ,

                (SELECT

                               POST.ITEM_CONTENT_ID

                FROM

                               FISHEYE_GALLERY_IMAGE_MAP POST

                WHERE

                               POST.GALLERY_CONTENT_ID = :parent_id

                               AND POST.ITEM_POSITION > FGIM.ITEM_POSITION

                ORDER BY

                               POST.ITEM_POSITION ASC ROWS 1) AS POST_ITEM_CONTENT_ID

FROM

                FISHEYE_GALLERY_IMAGE_MAP FGIM

WHERE

                FGIM.ITEM_CONTENT_ID = :content_id

Regards,

Karol Bieniaszewski