Oracle - Run PL/SQL Statements in SQL*Plus in Oracle

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.

⇒Introduction to Command-Line SQL*Plus Client Tool

⇒⇒Oracle Database Tutorials

2016-10-17, 439👍, 0💬

Popular Posts:

RAND() - Generating ...

How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...

Binary Literals in S...

What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...

Error: Subquery Retu...

What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...

SQL Server Transact-...

Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...

Formatting Time Zone...

How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...