select sysdate from dual
insert into pm_process
(process_id,
one_line,
description,
party_id,
creation_date)
values
(:process_id,
:one_line,
:description,
:party_id,
:creation_date)
update pm_process
set one_line = :one_line,
description = :description,
party_id = :party_id
SELECT process_id,
one_line,
description,
party_id,
creation_date
FROM pm_process
WHERE process_id = :process_id