What are the Blocks in PL/SQL?

Showing Answers 1 - 0 of 0 Answers

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

  Was this answer useful?  Yes

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

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions