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, 2649🔥, 0💬
Popular Posts:
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an ...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...