(That’s why SQL*Plus was originally known as an Advanced Friendly Interface ). This means SQL*Plus contains a number of features to make it friendlier and more useful. Originally, it was written as a SQL report writer. Unlike other SQL environments, the SQL*Plus environment isn’t limited simply to running SQL statements. When sqlplus is in the path environment variable, you can access it by typing the following: Linux installations require that you configure
This works when the operating system finds the sqlplus executable in its path environment variable ( $PATH on Linux). The statements are organized in the order that you generally encounter them as you start working with SQL*Plus or the MySQL Monitor.Ĭonnecting to and Disconnecting from SQL*PlusĪfter installing the Oracle Database on the Linux OS, you access SQL*Plus from the command line. SQL*Plus is the client software for Oracle that runs SQL statements and anonymous block PL/SQL statements in an interactive and batch development environment. There are many other commercial products from other vendors that let you work with Oracle, but coverage of those products is beyond the scope of this book.
ORACLE CMD LINE DISPLAYS NUMBERS AFTER BEGIN. GET BAC TO SQL PROMPT HOW TO
This section explains how to use these two primary interfaces to the SQL and PL/SQL engines. You can work either in the interactive SQL*Plus command-line interface (CLI) or in Oracle SQL Developer through a Java-based GUI. SQL*Plus provides an interactive and batch processing environment that dispatches commands to the SQL and PL/SQL engines.