from the View menu, select DBMS Output.in the DBMS Output window, click the green plus icon, and select your connection.right-click the connection and choose SQL worksheet.paste your query into the worksheet.run the query.
Can we use PL SQL in SQL Developer?
Once you have created and compiled a PL/SQL procedure, you can run it using Oracle SQL Developer.
How do I run a SQL script in PL SQL?
Answer: To execute a script file in SQLPlus, type @ and then the file name. The above command assumes that the file is in the current directory. (ie: the current directory is usually the directory that you were located in before you launched SQLPlus.) This command would run a script file called script.