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,

Example

SQL> set serveroutput on
SQL> DECLARE
    
    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';
BEGIN
    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);
END;
/

Example Result :

• « Previous
• Next »