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, 2370🔥, 0💬
Popular Posts:
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
How to put statements into a statement block in SQL Server Transact-SQL? You can put statements into...
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...