1SQLSH(1) User Contributed Perl Documentation SQLSH(1)
2
3
4
6 sqlsh - SQL shell
7
9 sqlsh -d DBI:Oracle:DEVDB -u scott -p tiger
10
12 sqlsh is an interactive shell run from the command-line for working
13 with databases. This is a terse summary for quick reference. For a
14 full description see SQL::Shell::Manual. For a list of commands, type:
15
16 help
17
18 at the prompt after running sqlsh. If you pass a username with -u and
19 don't pass a password with -p, sqlsh will prompt you for a password.
20 You can pass a blank password with -p if required (-p followed by
21 nothing).
22
24 -d <DSN>
25 -u <username>
26 -p <password>
27 -i - read list of commands from STDIN
28 -q - quiet (no banner)
29 -H - help
30
32 cat|more|less <file> - display file
33 help|? - show this
34 reload - reload the shell
35 exit|quit|bye|\w+ off - quit the shell
36
38 This script uses Term::Readline. Term::Readline sets the editing mode
39 (vi/emacs) based on the user's .inputrc, or the $EDITOR environment
40 variable.
41
42 This script will set $EDITOR based on $PERL_READLINE_MODE or bash's
43 $SHELLOPTS variable. Any .inputrc "editing-mode" declaration still
44 takes precedence.
45
47 $Revision: 1.50 $ on $Date: 2006/12/05 11:38:47 $ by $Author: andreww $
48
50 John Alden with contributions by Simon Flack <cpan _at_ bbc _dot_ co
51 _dot_ uk>
52
54 (c) BBC 2006. This program is free software; you can redistribute it
55 and/or modify it under the GNU GPL.
56
57 See the file COPYING in this distribution, or
58 http://www.gnu.org/licenses/gpl.txt
59
60
61
62perl v5.28.0 2015-08-11 SQLSH(1)