Oracle SQLPLUS Tutorials.
This page lists oracle sqlplus tutorials which will show you how to
use this basic interface to the Oracle database.
SQL*PLUS allows you to interact with the Oracle database engine
so you can create objects and manipulate data inside the database.
It is a tool which can be installed independently on a client workstation,
but it is also installed automatically with each Oracle database installation on the server.
Even though it is very basic, it is the primary tool for
accessing and testing connectivity to a database locally on a server.
There are 3 versions available,
- a command-line interface, which is what we use on this site to show our examples
- a GUI interface
- a web-based interface called iSQL*Plus
Below is a list of articles that will explain SQL*PLus functionality:
- Oracle SQL*Plus demo table setup
explains how to create the scott user and the demo tables which are used in examples throughout this site's articles. - Demobld.sql
Download demobld.sql here if it did not come installed with your Oracle software. - Demodrop.sql
Download demodrop.sql here if it did not come installed with your Oracle software. - SqlPlus BindVariables
An script to show you how to use sql*plus bind variables in a real-life example.
Recommended reading:
