关于Oracle DB中SQL Script的注释(REM,--,/* */)

Oracle DB中SQL Script注释的语法

   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 comment
end; 
/

begin
   REM comment
   DBMS_OUTPUT.PUT_LINE('Test');
end; 
/

11.2 documentation on all comment types 关于注释有很清楚的说明。

You 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.

转载请注明出处： http://blog.csdn.net/pan_tian/article/details/7745666

======EOF======