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
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/