اريد التأكد من ال Sql Statement

اريد التأكد من ال sql statement

create or replace trigger set_order_value
after insert on customer_order_product
begin
update customer_order set order_value=(select sum(order_qnt_no*unit_price) from customer_order_product);
end;

Create Or Replace Function Get_sum_orders
(date1 customer_order_product.order_date%type
, date2 customer_order_product.order_date%type )
return number
is
sum_orders_values customer_order.order_value%type;
Begin
select sum(order_qnt_no*unit_price)into sum_orders_values
from customer_order_product
where order_date between date1 and date2 ;
return sum_orders_values;
End;
/