SQL*Plus Scripts



SQL*Plus is a basic command line SQL and PL/SQL interface and reporting tool for Oracle which allows DBAs and developers to interact with the Oracle database. SQL*Plus is integrated with the Oracle Database Client and (up to version 10g) Server. As of Oracle vesion 11g, the SQL*Plus GUI version no longer ships with the database, however the command-line version is still integrated and widely used.

SQL*Plus Scripts

The SQL*Plus scripts below are intended to help both database administrators and developers. Most, if not all, of the scripts can be executed from Oracle's SQL Developer IDE and other popular database tools.

Login / Prompt Tablespace / Storage Performance Troubleshooting / Misc