How to declare a global variable in a package?

Question

Oracle

In the package, you need to declare a global variable, which later must be used in the trigger to count the number of changes in the table

Answer 1

You can read more on the Tom Kyte forum

create or replace package inte
as
  c_exact  constant number := 0.99;
end;

 
create or replace trigger t_trigger
before insert on t for each row
begin
        if ( :new.x >= inte.c_exact )
        then
           null;
        end if;
end;