Welcome to the community.
Here I am giving some steps that may help you to make your self familiar with SQL Navigator.
The PL/SQL stored procedures or objects need to be created in Database schema in order to execute them. On a fly it is not possible to execute and see the result like a SQL query.
Once you have created under any user of Database then they will be listed in SQLNAV Db Nav tree, under appropriate nodes like functions, procedures,packages e.t.c then if you don’t want them any more you can drop it from database by highlighting them and press delete button.
To clarify you question regarding executing it has to be executed from execution console.
For future reference these can be added to Code templates which are under View menu. Please add them to code template so that you can refer to them in future and they can be drag and drop to SQL editor and you can re create them if you want. Make sure if the pl/sql object creation script has create or replace then it will be replaced all the time irrespective of if you have it on database.
If you are executing anonymous block which is called un named block in oracle pl/sql then they can be executed straight away in SQL editor without creating on database. These blocks also can be stored in Code templates.
Anonymous blocks looks like this >>>>>>>>>>>>>>>>>
DBMS_OUTPUT.PUt_LINE (‘It Is working’);
Note: Please click on scan defines on (&) , if your code needs any variable to be defined. For anonymous blocks execution you don’t need to have any execution console.
- IF any pl/sql script looks like
Create or replace function/procedure/package/type
Then these are called named blocks or oracle objects. These need to be created against database inorder to execute it.