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.3.0
Name Modified Size InfoDownloads / Week
Parent folder
readme.txt 2017-07-13 1.4 kB
0
sqlps-0.3.0.zip 2017-07-13 546.8 kB
0
Totals: 2 Items   548.2 kB 0 
  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.
Source: readme.txt, updated 2017-07-13