PL/SQL Comment>

PL/SQL Comments you can write single line comments or either multiple line comments,

  • Multi-line comments and
  • Single line comments

Multi-line comments are delimited with /*..COMMENT TEXT..*/ and
Single-line comments starts with two dashes --.

PL/SQL Comments can begin in any column on any line. If you are embedding comments in SQL that will be embedded in PL/SQL you need to be careful for writing a column.

Comment Syntax

SQL>-- Single Line Comment
SQL>/*  Multiline Comment line 1
        Multiline Comment line2    */

Comment Example

This example is nothing any new same as last lesson only new for showing a how to write single line comment or multi line comment in PL/SQL program,


SQL> set serveroutput on
    eno number(5) NOT NULL := 2; --assign value into eno variable
    ename varchar2(15) := 'Branson Devs';
    /* Constant value is fixed for edept value is "Web Deloper" 
    is fixed all program not required declare all times. */
    edept CONSTANT varchar2(15) := 'Web Developer';
    dbms_output.put_line('Declared Value:');
    dbms_output.put_line(' Employee Number: ' || eno || ' Employee Name: ' || ename);
    dbms_output.put_line('Constant Declared:');
    dbms_output.put_line(' Employee Department: ' || edept);

Example Result :

Declared Value:
Employee number: 2 Employee Name: Branson Devs
Constant Declared:
Employee Department: Web Developer