For years, SQL*Plus has been the de facto standard tool for connecting to Oracle databases. Since the early versions of Oracle, it has been included as a part of any Oracle RDBMS installation. SQL*Plus is a command-line tool and is launched on all Oracle platforms using the command, sqlplus. This command-line tool has been a staple of Oracle DBAs for many years and has a powerful, interactive command interface that can be used to issue SQL statements, create database objects, launch scripts, and start up databases. For some beginners, that power comes at a price, in the form of SQL*Plus's somewhat steep learning curve. However, although SQL*Plus can be challenging to use as a SQL and PL/SQL development tool, it is an extremely useful ...

Get OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.