- 单行注释
- 多行注释
单行注释以"--"开始,例如:
-- DELETE FROM employees WHERE comm_pct IS NULL
多行注释以“/*”开始,以“*/”结束,例如:
/*
IF 2 + 2 = 4 THENsome_condition := TRUE;END IF;*/但是多行注释不能嵌套多行注释,例如:
/*IF 2 + 2 = 4 THEN some_condition := TRUE;/* We expect this THEN to always be performed */END IF;*/这是不允许的,会报语法错误。但是多行注释内可以包含单行注释,例如:/*IF 2 + 2 = 4 THEN some_condition := TRUE;-- We expect this THEN to always be performed END IF;*/这是允许的。但是多行注释内可以包含多行注释的开始字符,例如:/*IF 2 + 2 = 4 THEN some_condition := TRUE;/* We expect this THEN to always be performed END IF;*/这也是允许的。但不可以包含结束字符,例如:/*IF 2 + 2 = 4 THEN some_condition := TRUE;We expect this THEN to always be performed */ END IF;*/这是不允许的,存在语法错误
