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;

 

Different Types of PL/SQL Code Blocks in Oracle

PL/SQL Language Case Insensitive in Oracle

Understanding PL/SQL Language Basics

⇑⇑ Oracle Database Tutorials

2018-12-26, 1732🔥, 0💬