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, 2119🔥, 0💬
Popular Posts:
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...