PL/SQL Comment - Singleline Comment, Multiline 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.
SQL>-- Single Line Comment SQL>/* Multiline Comment line 1 Multiline Comment line2 */
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 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 :
Employee number: 2 Employee Name: Branson Devs
Employee Department: Web Developer