How to execute PLSQL Block

PL/SQL block code

?how to save
?how to execute

sql structured query language, pl/sql means programming language through sql.
in sql we can just write a single query and then execute it. if we need to run more than one command we can't do this in sql. for this purpose the pl/sql which is extension of sql gives us facility to do this.

block

declare
//used for declaring variables
begin
//starting of execution
exception
//user defined exception handling
end;
/

for printing output
set serverout on/off (off, we must have to manually on it on the connection with oracle).

how to execute the pl/sql code
1. Write the program on terminal
2. Copy and paste the code on terminal
3. execute the file with @ path of file

[atulvyas]

In a world where money is everything but Anand sir are doing it for free ...Keep doing the great work ....Thanks..

[dheerendrapratapsingh]

Very helpful for understand Pl/SQL environment