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, 867👍, 0💬
Popular Posts:
How To Count Duplicated Values in a Column in SQL Server? If you have a column with duplicated value...
How To Recreate an Existing Index in SQL Server? If you want to change the definition of an existing...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...