How Can I create my stored procedure?

[raf]

1- Write your storedproc in a file like yourfilename.sql
2- Compile your storedproc

Follows the basic syntax for your storedproc...

CREATE OR REPLACE PROCEDURE procedure_name IS
BEGIN
  put your code logic here
END procedure_name;
/

...then log into sqlplus and do @yourfilename.sql

Thanks but I don't Know write the code to update the column COUNTER with my conditions.

Have someone any idea?