What are the comments in Oracle PL/SQL code

This article introduces the knowledge about "What are the comments in Oracle PL/SQL code?" In the actual case operation process, many people will encounter such a dilemma. Next, let Xiaobian lead you to learn how to deal with these situations! I hope you can read carefully and learn something!

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

- single-line comments

- multiline comments

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

-- Delete FROM employees WHERE comm_pct IS NULL Multiline comments start with "/*" and end with "*/", e.g.:/* However, multiline comments cannot nest multiline comments, e.g.:/* 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 is reported. However, multi-line comments can contain single-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, a multiline comment can contain the opening character of the multiline comment, for example: /* IF 2 + 2 = 4 THEN some_condition := TRUE; /* We expect this THEN to always be performed END IF; */This is also allowed. However, it may not contain closing characters, such as: /* IF 2 + 2 = 4 THEN some_condition := TRUE; We expect this THEN to always be performed */ END IF; */This is not allowed, there is a syntax error "Oracle PL/SQL code in which there are several comments" content introduced here, thank you for reading. If you want to know more about industry-related knowledge, you can pay attention to the website. Xiaobian will output more high-quality practical articles for everyone!