What are the oracle code segment comment symbols?

Oracle code segment comment symbols start with "/*" and end with "*/". The comment method is such as "/*IF 2 2 = 4 THEN some_condition := TRUE; END IF;*/".

Recommended: "oracle tutorial"

Comments in Oracle PL/SQL code

Comments on Oracle PL/SQL code can be divided into two types:

- 单行注释
- 多行注释

Single-line comments start with "--", for example:

-- DELETE FROM employees WHERE comm_pct IS NULL

Multi-line comments start with "/ *" and ends with "*/", for example:

/*
 IF 2 + 2 = 4 THEN
        some_condition := TRUE; 
    END IF; 
*/

However, multi-line comments cannot be nested within multi-line comments, for example:

/*
     IF 2 + 2 = 4 THEN
        some_condition := TRUE;
     /* We expect this THEN to always be performed */ 
    END IF;
 */

This is not allowed and a syntax error will be reported. . However, single-line comments can be included within multi-line comments, for example:

/* 
  IF 2 + 2 = 4 THEN
    some_condition := TRUE; 
 -- We expect this THEN to always be performed
  END IF; 
*/

This is allowed. However, multi-line comments can contain the starting characters of multi-line comments, for example:

/* 
  IF 2 + 2 = 4 THEN
    some_condition := TRUE; 
 /* We expect this THEN to always be performed
  END IF; 
*/

This is also allowed. But it cannot contain ending characters, for example:

/* 
  IF 2 + 2 = 4 THEN
    some_condition := TRUE; 
 We expect this THEN to always be performed */
  END IF; 
*/

This is not allowed and there is a syntax error

The above is the detailed content of What are the oracle code segment comment symbols?. For more information, please follow other related articles on the PHP Chinese website!