Sanjay Bharti

• Jun 13th, 2007

 

Hi All,

I am new to this community. It seems the question is related to Begin End block of PL/SQL. See if you do not want to write any procedure and you want to do some sequence of operation that includes some calculation logic,queries etc, then you can use Begin End block....


Syntax is

Declare (optional if there is no variable)
<-- Declare the variables if any-->
Begin
<!-- Set of operations to be performed-->
End

You can also have Begin- End block inside the Procedure or function this is basically a block................

enjoy,
Sanjay Bharti

Ravindra Reddy

• Sep 5th, 2007

 

The PL/SQL Blocks are 2 types

1. Ananymous Block
2. Named Block

1. Ananymous Block means with out any name.
Ex:-
Declare
<variables>

Begin

<Exec Statmts>

Exception

End.

2. Names Block are Procedures/Functions/Triggers

Ok.....
        
Cheers

Rav'i'ndra Reddy