File	Date	Author	Commit
Build	2020-11-16	mavalog	[a81ab8] chore(project): mark version 0.7.0
Doc	2020-11-16	mavalog	[a81ab8] chore(project): mark version 0.7.0
Help	2020-11-16	mavalog	[a81ab8] chore(project): mark version 0.7.0
Script	2020-11-16	mavalog	[a81ab8] chore(project): mark version 0.7.0
Test	2020-11-11	mavalog	[550369] chore(script): add script tab-triggers.sql (ins...
AUTHORS	2016-12-19	mavalog	[265b7d] doc(project): add license and version information
COPYING	2018-02-07	mavalog	[05eb4a] feat(project): add help system, working in SQL*...
ChangeLog.txt	2020-11-16	mavalog	[a81ab8] chore(project): mark version 0.7.0
Makefile	2018-12-13	mavalog	[d0909e] chore(script): move script Utility/sps-version....
README.txt	2019-08-02	mavalog	[401d03] chore(script): add script tab-ind-cols.sql (ins...

Read Me

  This is SqlPlusScript, set of general-purpose SQL scripts for Oracle
database, designed to perform in Oracle SQL*Plus.

Home page:

https://sourceforge.net/projects/sqlpsc



  Description
  ===========

Project goal: to provide a comfortable environment to work in Oracle SQLPlus,
comparable in functionality and more efficient with constant use is different
than the GUI-applications to work with the database.

To work effectively, you also need to configure SQL*Plus (command history,
autocompletion, etc.). This can be done using the SqlPlusConfig project
(home page: https://sourceforge.net/projects/sqlpc).



  Installation
  ============

1. Copy the directory with scripts (Script) in the working directory of
  SQL*Plus with some short name (for example as "c:/oracle/scripts/sps"
  in MS Windows or "/home/oracle/scripts/sps" in Linux).

2. Define 2 variables (SPS_SCRIPT_DIR, SPS_TEMP_FILE_PREFIX) and run
  initialization script (Script/SpsConfig/init.sql) in SQL*Plus.

  Example (MS Windows):

SQL> define SPS_SCRIPT_DIR = "c:/oracle/scripts/sps"
SQL> define SPS_TEMP_FILE_PREFIX = "c:/temp/sqlpsc.tmp.135."
SQL> @"&SPS_SCRIPT_DIR/SpsConfig/init.sql"

(where "135" is any unique Id, for example Process ID)

  Example (Linux):

SQL> define SPS_SCRIPT_DIR = "/home/oracle/scripts/sps"
SQL> define SPS_TEMP_FILE_PREFIX = "/tmp/sqlpsc.tmp.135."
SQL> @"&SPS_SCRIPT_DIR/SpsConfig/init.sql"

3. It is recommended to add the full path to scripts root directory in
  SQLPATH environment variable. This will allow you to call the project scripts
  in the SQL*Plus without specifying the additional path (for example,
  "@select ...").

  Example (MS Windows):

SQLPATH=c:\oracle\scripts\sps

  Example (Linux):

SQLPATH=/home/oracle/scripts/sps



  Documentation
  =============

Use help system of this project in SQL*Plus:

SQL> @help ""

or

SQL> @&SPS_SCRIPT_DIR/help ""

Getting help on the script (for example, for "select.sql"):

SQL> @help select.sql

or

SQL> @select.sql :?

(for scripts that use query options, if there is connection to database)

Getting help on query options that you can use with the script:

SQL> @help queryOptions

or

SQL> @select.sql :??

(for scripts that use query options, if there is connection to database)

Changes in versions:

ChangeLog.txt

Developer's documentation (in Russian/English):

Doc/Html/ru/index.html