1SQLSH(1)              User Contributed Perl Documentation             SQLSH(1)
2
3
4

NAME

6       sqlsh - SQL shell
7

SYNOPSIS

9               sqlsh -d DBI:Oracle:DEVDB -u scott -p tiger
10

DESCRIPTION

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

OPTIONS

24               -d <DSN>
25               -u <username>
26               -p <password>
27               -i - read list of commands from STDIN
28               -q - quiet (no banner)
29               -A - turn AutoCommit ON
30               -H - help
31

COMMANDS ADDED BY SQLSH

33        cat|more|less <file> - display file
34        help|? - show this
35        reload - reload the shell
36        exit|quit|bye|\w+ off - quit the shell
37

READLINE MODE

39       This script uses Term::Readline. Term::Readline sets the editing mode
40       (vi/emacs) based on the user's .inputrc, or the $EDITOR environment
41       variable.
42
43       This script will set $EDITOR based on $PERL_READLINE_MODE or bash's
44       $SHELLOPTS variable. Any .inputrc "editing-mode" declaration still
45       takes precedence.
46

VERSION

48       Version 1.17
49

AUTHOR

51       John Alden with contributions by Simon Flack and Simon Stevenson <cpan
52       _at_ bbc _dot_ co _dot_ uk>
53
54       Miguel Gualdron maintainer.
55
57           SQL-Shell:  Interactive shell for DBI Databases
58           Copyright (C) 2006  BBC
59           Copyright (C) 2019  Miguel Gualdron
60
61           This program is free software; you can redistribute it and/or modify
62           it under the terms of the GNU General Public License as published by
63           the Free Software Foundation; either version 2 of the License, or
64           (at your option) any later version.
65
66           This program is distributed in the hope that it will be useful,
67           but WITHOUT ANY WARRANTY; without even the implied warranty of
68           MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
69           GNU General Public License for more details.
70
71           You should have received a copy of the GNU General Public License
72           along with this program; if not, write to the Free Software
73           Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
74
75       See the file COPYING in this distribution, or
76       https://www.gnu.org/licenses/gpl-2.0.html
77
78
79
80perl v5.36.0                      2023-01-20                          SQLSH(1)
Impressum