Enter Comments in PL/SQL in Oracle

Q

How To Enter Comments in PL/SQL in Oracle?

✍: FYIcenter.com

A

There are two ways to enter comments into PL/SQL codes:

  • SQL Statement Style: Starts you comment any where in the line but prefixed with '--'. The comment ends at the end of the line.
  • C Language Style: Starts you comment any where in the line with '/*' and ends it with '*/' in the same line or some lines below.

Here is some example of PL/SQL comments:

BEGIN
  -- This is a comment
  /* To do:
     Need to write some codes here 
  */
END;

 

⇒Understanding PL/SQL Language Basics

⇒⇒Oracle Database Tutorials

2016-10-17, 470👍, 0💬

General MySQL Oracle SQL Server