Run PL/SQL Statements in SQL*Plus in Oracle

Q

How To Run PL/SQL Statements in SQL*Plus in Oracle?

✍: FYIcenter.com

A

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

Introduction to Command-Line SQL*Plus Client Tool

⇑⇑ Oracle Database Tutorials

2020-07-22, 2130🔥, 0💬