DEV Community

Query Filter
Query Filter

Posted on

sql2

-- 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...

Enter fullscreen mode Exit fullscreen mode

Top comments (0)