Comments and assign

 Top  Previous  Next

Oracle comments

Progress comments

/*

Multiple lines

*/

-- This is a single line comment

/*

Multiple lines

*/

 

Assign

Oracle

Progress

v_variable := value ;

assign v_variable = value.  

or

v_variable = value.

 

Constants in PL/SQL are variables that are assigned a value at declaration and that value could not be changed.

v_tax_percent CONSTANT NUMBER(4,3) := 0.025 ;