Introduction PL/SQL

Basic PL/SQL

Advance PL/SQL

PL/SQL Comments


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.

PL/SQL Comments Syntax

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


Comments 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 Code :

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 :

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