SqlPlusScript Files

  Version 0.7.0 ( 2020-11-11)
  ===========================

Version goal: replace obsolete scripts table-*.sql with new scripts tab-*.sql.

[+] Add script tab-list.sql to show list of tables, views and clusters.

[+] Add script tab-cols.sql to describe columns of tables, views and clusters.

[*] Add scripts tab-col-desc.sql, tab-desc.sql (instead of obsolete scripts table-column.sql, table-comment.sql).

[*] Add script tab-ind-cols.sql (instead of scripts ind-columns.sql and table-index-column.sql).

[*] Add script tab-indexes.sql (instead of obsolete script tab-index.sql).

[*] Add scripts <tab-constraints.sql>, <tab-ref-constraints.sql> (instead of obsolete scripts table-constraint.sql, table-r-constraint.sql).

[*] Add script tab-partitions.sql (instead of obsolete scripts table-partition.sql and table-partition-w.sql).

[*] Add script <tab-triggers.sql> (instead of obsolete script table-trigger.sql).

[*] Set default output limit for scripts to 1000 rows (previously 100 rows).

[*] Clarify help for scripts and README.

[-] Remove script tabs.sql (use tables.sql instead).



  Version 0.6.0 ( 2018-12-24)
  ===========================

[*] Initialization script .spsInternal/init-var.sql moved to SpsConfig/init.sql. It is necessary to make changes to call line of this script in user settings.

[*] Add scripts tables.sql, tabs.sql (instead of obsolete scripts table.sql, table-p.sql, table-w.sql).

[*] Script Utility/sps-version.sql moved to SpsConfig/version.sql.

[*] Script Utility/set-sps-script-dir.sql moved to SpsConfig/set-script-dir.sql.

[+] Add scripts to control debugging output (SpsConfig/debug-on.sql, SpsConfig/trace-on.sql, SpsConfig/debug-off.sql).

[!] Allow point in object name pattern.



  Version 0.5.0 ( 2018-08-31)
  ===========================

[+] Add query option "o" for specify custom sorting.

[+] Use query option "C" for specify additional columns, displayed after default columns (previously, the "C" option was used to limit the number of output rows).

[*] Value for query option "g" should be specified first (before value for "c" option, if it is used).

[*] Remove unnecessary re-sorting in case of display last record (using query options ":t1").

[-] Remove query options "X", "L", "D", "M" (Roman numerals), used for limiting the number of output rows (use numbers instead of them, for example "10" instead of "X").

[-] Remove sophisticated query option "R", used for sorting.



  Version 0.4.0 ( 2018-07-04)
  ===========================

[+] Add help system, working in SQL*Plus (accessed by help.sql). Add help topics about installation, settings, query options and few scripts.

[+] Add query options for getting help on the executed script (for example, "@select.sql :?") and on query options (for example, "@select.sql :??").

[+] Add script for setting SqlPlusScript scripts directory, used in SQL*Plus (Utility/set-sps-script-dir.sql).

[+] Add make goal "add-version" for simplify adding new version of project.

[*] Rename unixname of project from "sqlps" to "sqlpsc" (with similar change in URL of home page), developer's documentation moved to Doc/Html/ru directory.

[*] Rename scripts according to main view used in them (dependency.sql to dependencies.sql, index-column.sql to ind-columns.sql).

[!] Fixes for use scripts with query options in "clean SQL*Plus" (without custom settings).



  Version 0.3.0 ( 2017-07-14)
  ===========================

[+] Added the ability to specify the query options, which are used by default for the specified script ( using SPS_SCRIPT_DEFAULT_OPTION variable).

[*] Maximum number of output rows in the query execution options is set by a number (continuous sequence of digits from 0 to 9) or Roman numerals starting with "X" ("X", "L", "C", "D", "M"). The previously used options "N", "m", "n" are not supported, and the "M" option has changed the value (no more than 1000 instead of 300 records).

[*] Refactoring use of query options:
	- generate query in PL/SQL, also unused lines were excluded instead of save it as comment lines;
  - substitute all variables ( with exception of bind variables) in query;

[*] Added autotests ( run from Test/run.sql).

[*] Use UTF-8 files encoding ( instead of CP1251).

[*] Scripts select.sql, spool-on.sql, spool-off.sql were moved from subdirectory Common into scripts root directory with a recommendation add scripts root directory to SQLPATH ( instead of a subdirectory Common).

[-] Default setting to limit output no more than 10 rows was removed from select.sql script ( which had priority over query options specified in SPS_DEFAULT_OPTION).

[!] Fixed bug when using single quotes in the argument string select.sql.

[!] Fixed bug when using global name as database link in query options string.



  Version 0.2.0 ( 2017-03-31)
  ===========================

Added scripts:
- to view dependencies between database objects ( dependency.sql, reference.sql);
- to view blocking sessions ( Session/block.sql);
- to view blocking sessions on objects in the library cache ( Session/library-block.sql);
- to view SQL execution plan that is executed in session ( Session/plan.sql);
- to kill session ( Session/kill.sql);
- to start or stop spooling to file ( Common/spool-on.sql, Common/spool-off.sql);

Refactoring use of query options:
- use the option "1" instead of "o" to select at most one record;
- discontinued use of "with", which improved the query execution plan in some cases;
- substitute variables and delete extra lines in base query;
- query of variables 3, 4, 5 is excluded;



  Version 0.1.0 ( 2016-12-23)
  ===========================

Added scripts:
- to retrieve data with using query options Common/select.sql ( as well as the pilot script index-column.sql using the query options to a static query);
- to view the database objects ( table.sql, view.sql, etc.);
- to view information about sessions ( Session/by-sid.sql, Session/longops.sql, Session/wait.sql, etc.);
- to view executes SQL ( Sql/last.sql, etc.);
- to unload data from table in SQL*Loader format ( Utility/unload-table-data.sql);