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................
Latest Answer : The PL/SQL Blocks are 2 types1. Ananymous Block2. Named Block1. Ananymous Block means with out any name.Ex:- DeclareBeginExceptionEnd.2. Names Block are Procedures/Functions/TriggersOk..... CheersRav'i'ndra ...
The Building Blocks of ERP Enterprise Resource Planning is commonly used to improve the integration within companies and organizations and instead of focusing on individual parts the operations of the company are viewed as a whole Software infrastructure plays an important role in this process In ad
This Week we will be learning about Creating PL SQL Blocks which includes Declaration Section Variables Scope of Variables Constants Records Manipulating Data in PL SQL and Using DML in PL SQL mosgoogle PL SQL is a procedural extension for Oracle’ s Structured Query Language PL SQL is not
