在需要使用单引号的时候,'' 两个单引号代表一个单引号
在plsql中不能使用dbms_output.put_line(' ');来输出空行,这样会自动被plsql忽略掉
正确的方法是使用chr()函数进行转换
dbms_output.put_line(CHR(1));
dbms_output.put_line('--------------------------------------------');
dbms_output.put_line('Warning:There is no trigger need to disable.');
dbms_output.put_line('--------------------------------------------');
dbms_output.put_line('--------------------------------------------');
dbms_output.put_line('Warning:There is no trigger need to disable.');
dbms_output.put_line('--------------------------------------------');
输出结果如下:
SQL> exec opr_trigger_pkg.disable_trigger('HXY');
-----空行
--------------------------------------------
Warning:There is no trigger need to disable.
--------------------------------------------
PL/SQL procedure successfully completed.
-----空行
--------------------------------------------
Warning:There is no trigger need to disable.
--------------------------------------------
PL/SQL procedure successfully completed.
转载于:https://blog.51cto.com/haoxy/1353130