create procedure dateofbookpublication 
@booktemplate varchar(MAX) 
as
begin 
update [BOOKS (book)] set DateofPublish =Dateadd(YEAR,2,DateofPublish)
where [BOOKS (book)].NameBook like '%'+@booktemplate+'%'
end
select NameBook, DateofPublish from [BOOKS (book)]
execute dateofbookpublication 'вій'
go

create or replace procedure publication_books(name_of_book varchar2)
as 
begin 
update books add_months(b.date_of_publish,24) as new_publish_date from dual;