oracle8.1.6 select item_id from attachments where object_id = :object_id and approved_p = 't' select item_id, approved_p from attachments where object_id = :object_id