DEV Community

Query Filter
Query Filter

Posted on

sql6

SET VERIFY OFF
SET FEEDBACK OFF
SET HEADING OFF
SET ECHO OFF

-- Define with default value to avoid prompting
DEFINE p_flag = "N"
DEFINE p_flag = "&1"

-- Check and exit
EXIT SUCCESS WHEN UPPER(TRIM('&&p_flag')) != 'Y'

-- Main script continues
PROMPT Running utils.sql...
-- Rest of your script here...
Enter fullscreen mode Exit fullscreen mode

Top comments (0)