Google News
logo
PL/SQL - Interview Questions
What are the ways of commenting in a PL/SQL code?
Comments are the text which is included with the code to enhance readability and for the understanding of the reader. These codes are never executed.
 
There are two ways to comment in PL/SQL :
 
* Single line comment : This comment starts with double .
 
Example :
DECLARE
num NUMBER(2);        — it is a local variable.
BEGIN
 
* Multi-line comment : This comment starts with /* and ends with */.
 
Example :
BEGIN
num := &p_num;         /* This is a host variable used in program body */
……….
END
Advertisement