Oracle DB中SQL Script注释的语法
11.2 documentation on all comment types 关于注释有很清楚的说明。
REM Single line comment -- Single line comment /* Single line comment */ /* Multi Line comment */
补充:REM是REMARK的缩写
那么REM和--的区别是什么?
--或者/* */可以用于PL/SQL,但REM[ark]不可以。
下边这段可以在SQL*PLUS中执行成功
REM comment-- comment/* comment */begin DBMS_OUTPUT.PUT_LINE('Test'); --comment DBMS_OUTPUT.PUT_LINE('Test'); /* comment */end; /
但下边这段就不行
begin DBMS_OUTPUT.PUT_LINE('Test'); REM commentend; /begin REM comment DBMS_OUTPUT.PUT_LINE('Test');end; /
11.2 documentation on all comment types 关于注释有很清楚的说明。
转载请注明出处: http://blog.csdn.net/pan_tian/article/details/7745666You can enter comments in a script in three ways:
using the SQL*Plus REMARK command for single line comments.
using the SQL comment delimiters /*... */ for single or multi-line comments.
using ANSI/ISO (American National Standards Institute/International Standards Organization) comments - - for single line comments.
======EOF======
再分享一下我老师大神的人工智能教程吧。零基础!通俗易懂!风趣幽默!还带黄段子!希望你也加入到我们人工智能的队伍中来!https://blog.csdn.net/jiangjunshow