PLSQL block and Syntax

A PL/SQL block contains the following parts

1.      Declaration part                        

2.      Executable part and

3.      Exception handling part.

The general syntax is as follows:

[declare]

   Variables as well as types.

begin

   Executable statements

[Exception]

Handlers

end;

 These are some new operators in PL/SQL:

:= Assignment,        

||  Concatenation,

- -  Single line comment,

** Exponentiation,       

 . . Range Operator,       

<<>> Label Delimiter

% Attribute Indicator.             

/*  */ Multiline Comments.