General MySQL Oracle SQL Server

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, 3145🔥, 0💬

General MySQL Oracle SQL Server