---- 字符串换行
-- 使用exec时不能换行
SQL> exec DBMS_OUTPUT.put_line ('Hello World! '||chr(10)||'Hello World!');
Hello World!
Hello World!
PL/SQL procedure successfully completed
SQL>
SQL> begin
2 DBMS_OUTPUT.put_line ('Hello World!
3 Hello World!');
4 end;
5 /
Hello World!
Hello World!
PL/SQL procedure successfully completed
SQL>
----- The End -----
阅读(955) | 评论(0) | 转发(0) |
