Download Latest Version SqlPlusScript-0.7.0.zip (819.8 kB)
Email in envelope

Get an email when there's a new version of SqlPlusScript

Home / 0.7.0
Name Modified Size InfoDownloads / Week
Parent folder
SqlPlusScript-0.7.0.zip 2020-11-16 819.8 kB
0
README.txt 2020-11-16 2.5 kB
0
Totals: 2 Items   822.2 kB 0 
  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
Source: README.txt, updated 2020-11-16