关于Oracle DB中SQL Script的注释(REM,--,/* */)
关于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;
- /
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.
评论暂时关闭