How to Edit,Save and Execute a PL/SQL block?

How to Edit,Save and Execute a PL/SQL block?

Editing or creating new sql file:
You can use the edit command for editing an existing file or creating new one

SQL> ed c:\new.sql

If the file new.sql not exixting, then a new file named new.sql will be created.

After entering this command, a note pad file will be opened.You can write the PL/SQL block in this file.

Saving sql file:
Remeber you should save this file as sql file.That is the file extension should be .sql

Executing the Pl/SQL block:

You can execute the pl/sql sql block stored in a file by entering the command
@filename or exec[ute] filename

SQL> @ c:\new.sql

or
SQL> exec new.sql