Mercurial > sqlpython

comparison docs/source/capabilities.rst @ 456:46589473c36b

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
added makefile to docs
author catherine@dellzilla
date Wed, 17 Feb 2010 15:39:33 -0500
parents b34ea206c7d1
children 539c11ad1b7e
comparison
equal deleted inserted replaced
455:f664c32fcb3f 456:46589473c36b
35 `@http://scripthost/scriptlibrary/script.sql`. 35 `@http://scripthost/scriptlibrary/script.sql`.
36 36
37 History 37 History
38 ======= 38 =======
39 39
40 If used on a *nix machine with ``readline`` installed, then ``bash``-like access 40 If used on a \*nix machine with ``readline`` installed, then ``bash``-like access
41 to the command history is available. 41 to the command history is available.
42 42
43 The up- and down-arrow keys allow you to scroll through the lines entered so far 43 The up- and down-arrow keys allow you to scroll through the lines entered so far
44 in your sqlpython session. 44 in your sqlpython session.
45 45
280 Wild SQL is a nonstandard SQL feature that must be enabled with `set wildsql on`. When it is 280 Wild SQL is a nonstandard SQL feature that must be enabled with `set wildsql on`. When it is
281 enabled, column names in a SELECT statement do not need to be explicitly typed; they can be 281 enabled, column names in a SELECT statement do not need to be explicitly typed; they can be
282 specified with special Wild SQL symbols: wildcards (`*`, `%`, `_`); column numbers (`#{N}`); 282 specified with special Wild SQL symbols: wildcards (`*`, `%`, `_`); column numbers (`#{N}`);
283 and NOT-style exclusion (`!`). The symbols can even be combined. 283 and NOT-style exclusion (`!`). The symbols can even be combined.
284 284
285 TODO: column number Wild SQL is not working as of sqlpython 1.7.0
286
285 :: 287 ::
286 288
287 jrrt@orcl> cat party 289 jrrt@orcl> cat party
288 290
289 NAME STR INT WIS DEX CON CHA 291 NAME STR INT WIS DEX CON CHA
456 scan Interpret & as indicating substitution variables True 458 scan Interpret & as indicating substitution variables True
457 serveroutput Print DBMS_OUTPUT.PUT_LINE results True 459 serveroutput Print DBMS_OUTPUT.PUT_LINE results True
458 sql_echo Print text of "behind-the-scenes" queries False 460 sql_echo Print text of "behind-the-scenes" queries False
459 timeout In seconds 30 461 timeout In seconds 30
460 timing Print time for each command to execute False 462 timing Print time for each command to execute False
461 wildsql Accept *, %, #, and ! in column names False 463 wildsql Accept \*, %, #, and ! in column names False
462 ===================== =================================================== =============== 464 ===================== =================================================== ===============
463 465
464 The user can change these with the `set {paramname} {new-value}` statement. 466 The user can change these with the `set {paramname} {new-value}` statement.
465 The True/False parameters accept new values permissively, recognizing "True", "False", 467 The True/False parameters accept new values permissively, recognizing "True", "False",
466 "T", "F", "yes", "no", "on", "off", etc. 468 "T", "F", "yes", "no", "on", "off", etc.