SQL/PLSQL:Oracle绑定变量使用实例 define undefine verify

define undefine的使用实例

给测试写了个清数脚本

因为测试小哥只会用PLsql刷脚本 所以使用绑定变量 方便测试清空业务表的数据

脚本如下:

UNDEFINE v_AAAA_id
UNDEFINE v_BB_id
SET VERIFY ON
DEFINE v_AAAA_id = '&输入AAAA_id'
DEFINE v_BB_id = '&输入BBBB_id'
SET VERIFY OFF


SET ECHO ON
delete from XXXXXXSSB_SB   where AAAA_id = '&v_AAAA_id' and BB_id = '&v_BB_id' ; 
delete from XXXXXXSJH_SB   where AAAA_id = '&v_AAAA_id' and BB_id = '&v_BB_id' ; 
delete from XXXXXXb        where AAAA_id = '&v_AAAA_id' and BB_id = '&v_BB_id' ; 
--略
delete from XXXXXXIP       where AAAA_id = '&v_AAAA_id' and BB_id = '&v_BB_id' ; 
delete from XXXXXX         where AAAA_id = '&v_AAAA_id' and BB_id = '&v_BB_id' ; 
delete from XXXXXXJD       where AAAA_id = '&v_AAAA_id' and BB_id = '&v_BB_id' ; 
delete from XXXXXXTHS_MX   where AAAA_id = '&v_AAAA_id' and BB_id = '&v_BB_id' ; 
SET ECHO OFF


UNDEFINE v_AAAA_id
UNDEFINE v_BB_id

--commit;