sql

#!/bin/bash

LOAD_UTILS=Y   # or N

sqlplus -s user/pass@db <<EOF
@utils.sql $LOAD_UTILS   -- pass flag as &1

-- hard-coded SQL continues here
SELECT 'main code running' FROM dual;
EOF


-- utils.sql

COLUMN run NEW_VALUE run

SELECT CASE WHEN '&1' = 'Y'
            THEN 'prompt Running utils.sql...'
            ELSE 'exit'
       END AS run
FROM dual;

&run

------------------------------------------------------------
-- the rest of utils.sql (procedures, packages, etc.)
------------------------------------------------------------