Introduction to Oracle SQL*Plus

Overview

In this tutorial, we will learn Oracle SQL*Plus. Oracle SQL*Plus is a database client program with which we can access the backend database. We can execute SQL*PLUS, SQL, PL/SQL commands with the tool.

It is an interactive query tool that is in-built and installed along with the Oracle database. We will use Windows operating system in this tutorial.

Start SQL*Plus

This section shows how to start SQL*Plus tool on Windows.

We can launch the tool from the Start Menu.

Start Menu >> Oracle >> SQL Plus

Alternatively, we can launch the tool from Command prompt. We can find the tool in the bin directory i.e ORACLE_HOME/bin. ORACLE_HOME is a system environment variable that points to the Oracle database install folder.

Launch Command Prompt.

Change directory to the ORACLE_HOME/bin directory. We can also append the directory to the PATH environment variable. So that we can type the sqlplus command from anywhere in the directory tree. PATH is a variable with series of directory paths. The Command prompt would search for the command in the PATH.

Issue the following command:

\> sqlplus /nolog

 

sqlplus nolog command

The /nolog command option starts SQL*Plus tool without connecting to a
database.

To know the version of the tool, supply the -v command line switch.

\> sqlplus -v

C:\TestingDocs>sqlplus -v

SQL*Plus: Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

 

—

Database Tutorials on this website:

https://www.testingdocs.com/oracle-database-tutorials-for-beginners/

More information about Oracle Database:

https://www.oracle.com/database/

Related Posts