79674623

Date: 2025-06-21 17:40:21
Score: 1
Natty:
Report link
CREATE OR REPLACE PROCEDURE CleanupShiftLogs 
AS
    SHIFTNOTE_COUNT_1 CONSTANT NUMBER := 200,
    SHIFTNOTE_COUNT_2 CONSTANT NUMBER:= 350,
    OLDER_THAN_MONTHS NUMBER := 2;

BEGIN

 

    -- SQL STATEMENTS --
END CleanupShiftLogs;

-- SHIFTNOTE_COUNT_3 CONSTANT NUMBER; -->  If it is a constant, you need to initialize it at declaration.
Reasons:
  • Has code block (-0.5):
  • Unregistered user (0.5):
  • Low reputation (1):
Posted by: manisha