rem *********************************************************************
rem * Copyright © Oracle-Consultant.co.uk 2001, all rights reserved     *
rem *                                                                   *
rem * Name     : sqlpluscondition.sql                                   *
rem * Synopsis : Shows an example of conditional logic in SQL*Plus      *
rem *            Please remember to customise the script before use.    *
rem * Source   : http://www.oracle-consultant.co.uk                     *
rem *                                                                   *
rem * Oracle-Consultant.co.uk are not responsible for any liability     *
rem * that may arise from the use of this code. Support can be obtained *
rem * by emailing script_support@oracle-consultant.co.uk                *
rem * Note: This script is best viewed in a fixed-width font.           *
rem *********************************************************************

set verify off
accept continue char prompt 'Warning: About to remove rows from My_Table. Do you want to continue? (y|n) [n]: '

delete from My_Table
where  My_Column = 'condition'
and    upper('&continue') = 'Y';

commit;