sql4

SET VERIFY OFF
SET FEEDBACK OFF
SET HEADING OFF

-- Capture argument safely
DEFINE arg1 = '&1'

-- Replace null/empty with default 'N'
COLUMN arg1_val NEW_VALUE arg1_val
SELECT NVL(TRIM('&arg1'), 'N') AS arg1_val FROM dual;

-- Exit if not Y
COLUMN run_flag NEW_VALUE run_flag
SELECT CASE
         WHEN UPPER('&arg1_val') = 'Y' THEN 'RUN'
         ELSE 'EXIT'
       END AS run_flag
FROM dual;

-- Exit if needed
DEFINE run_flag = '&run_flag'
EXIT WHEN '&run_flag' = 'EXIT'

-- Main script continues
PROMPT Running utils.sql...