Thursday, August 18, 2016

PLSQL Comments


PLSQL  Comments

Use  -- for single line comments
Use /* */ for multiple line comments

Eg: Comments before a piece of code- to narrate what the code is about
 --cursor to get all the records in a particular department
   CURSOR  cur_employees IS SELECT  employee_id, first_name, salary from employees where department_id=10;

Eg: Comments to show the version of a PLSQL program unit, generally it is a good practice to maintain the history of modifications.
/*
Created by
Created Date
Description


modified by
modified date
description
search tag

modified   by
modified date
description
search tag


*/

Featured Post

Will the data from Oracle Database be lost after formatting the system in which it is installed?

So Someone asked me a question,  Will the data from Oracle Database be lost after formatting the system in which it is installed? Since the ...

Popular Posts