CREATE OR REPLACE FUNCTION Year_Value
      (value_in IN DATE)
      RETURN VARCHAR2
    AS
       value_out VARCHAR2(50);
    BEGIN
        value_out := TO_CHAR(value_in, 'YEAR');
        RETURN value_out;
    END;
    
   commit;
   
   select Year_Value(order_date)
   from customer.orders;