PLSQL Block of Code

PL/SQL Block of code
is an extension of SQL. That means Programming Language through structured query language. Before this extension we can only write and execute one query at a time on terminal but now with the help of this code of block we can perform multiple operations and execute many statements at a single time.
The code is compiled and acknowledge the errors if any we can also handle the exceptions at our own by using the exceptions section. Let's see the block of PL/SQL.

Declaration
---------------------------
Begin
-------------------------
Exception
-------------------------
End;
/

The First Section includes the declaration of the variable used in our program.
The second section begin includes the statements which are for processing.
The third one is optional can only be used when user wants to handle exceptions on it's own. Otherwise system will handle the errors and acknowledge you.
The forth section is ending section which tell the system that now program is ended no executable statement will be written after that.
./ this slash will compile the program when firstly used after that / if used then it executes the program.

for more information and query plz feel free to write to me on

[email protected]

or you can see more videos on my website that is

https://www.anandharsha.wordpress.com

Thanks
Anand Harsha.