Collections:
Run PL/SQL Statements in SQL*Plus in Oracle
How To Run PL/SQL Statements in SQL*Plus in Oracle?
✍: FYIcenter.com
If you want to run a single PL/SQL statement in SQL*Plus, you need to use the EXECUTE command as shown in the following tutorial example:
SQL> SET SERVEROUTPUT ON
SQL> EXECUTE DBMS_OUTPUT.PUT_LINE('Welcome to FYIcenter!')
Welcome to FYIcenter!
PL/SQL procedure successfully completed.
⇒ Change SQL*Plus System Settings in Oracle
⇐ Run SQL Commands in SQL*Plus in Oracle
2020-07-22, 4265🔥, 0💬
Popular Posts:
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
How To View Data Files in the Current Database in Oracle? If you want to get a list of all tablespac...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...