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, 2124🔥, 0💬
Popular Posts:
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...