-- utils.sql
-- Prevent SQL*Plus prompting for missing argument
COLUMN arg1 NEW_VALUE arg1
SELECT NVL('&1', '') AS arg1 FROM dual;
DEFINE 1="&arg1"
COLUMN run NEW_VALUE run
SELECT CASE
WHEN UPPER(TRIM('&1')) = 'Y'
THEN 'prompt Running utils.sql...'
ELSE 'exit'
END AS run
FROM dual;
&run
------------------------------------------------------
-- rest of utils.sql...
For further actions, you may consider blocking this person and/or reporting abuse
Top comments (0)