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, 200👍, 0💬

Popular Posts:

Managing Security, L...

Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...

READ_ONLY/READ_WRITE...

How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...

Using SELECT Stateme...

Can SELECT Statements Be Used on Views in SQL Server? Select (query) statements can be used on views...

IF ... ELSE Statemen...

How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...

Running Queries with...

How to run Queries with "sqlcmd" tool in SQL Server? "sqlcmd" is a client tool that you can use to i...