select *
from research_papers
where paper_id = :paper_id
update research_papers
set revision_id = :revision_id,
title = :title,
abstract = :abstract,
paper_url = :paper_url,
publication_date = :publication_date,
last_updated = sysdate,
type = :type,
subject = :subject,
identifier = :identifier,
source = :source,
lang = :lang,
rights = :rights,
license_url = :license_url,
public_p = :public_p
where paper_id = :paper_id
update research_papers
set public_p = :public_p
where paper_id = :paper_id