WHENEVER SQLERROR EXIT AND DML

最新推荐文章于 2023-12-14 10:08:02 发布

scan724

最新推荐文章于 2023-12-14 10:08:02 发布

阅读量1.2k

点赞数

分类专栏：数据库维护

本文链接：https://blog.csdn.net/zhaoyangjian724/article/details/89710913

版权

数据库维护专栏收录该内容

109 篇文章 31 订阅 ¥39.90 ¥99.00

订阅专栏

1.
SQL> create table test_dml(id int);

Table created.

SQL> select * from test_dml;
select * from test῟dml
                  *
ERROR at line 1:
ORA-00911: 无效字符


SQL> select * from test_dml;

no rows selected



[oracle@yyjk 20190430]$ cat all.txt 
WHENEVER SQLERROR EXIT
@a1.sql
COMMIT;
@a2.sql
COMMIT;
[oracle@yyjk 20190430]$ 
[oracle@yyjk 20190430]$ cat a1.sql 
insert into test_dml values(111);
insert into test_dml values('aaa');

[oracle@yyjk 20190430]$ cat a2.sql
insert into test_dml values(222);
insert into test_dml values('bbb');


With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@yyjk 20190430]$ sqlplus tlcbuser/tlcbuser

SQL*Plus: Release 11.2.0.4.0 Production on 星期二 4月 3

了解本专栏