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.
2020-07-22, 877👍, 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 set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
How To Create a Test Table for Transaction Testing in Oracle? If you want to practice DML statements...
What Are Logical/Boolean Operations in SQL Server Transact-SQL? Logical (Boolean) operations are per...