Miguel Gualdron
and 2 contributors

NAME

sqlsh - SQL shell

SYNOPSIS

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

DESCRIPTION

sqlsh is an interactive shell run from the command-line for working with databases. This is a terse summary for quick reference. For a full description see SQL::Shell::Manual. For a list of commands, type:

        help

at the prompt after running sqlsh. If you pass a username with -u and don't pass a password with -p, sqlsh will prompt you for a password. You can pass a blank password with -p if required (-p followed by nothing).

OPTIONS

        -d <DSN>
        -u <username>
        -p <password>
        -i - read list of commands from STDIN
        -q - quiet (no banner)
        -A - turn AutoCommit ON
        -H - help

COMMANDS ADDED BY SQLSH

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

READLINE MODE

This script uses Term::Readline. Term::Readline sets the editing mode (vi/emacs) based on the user's .inputrc, or the $EDITOR environment variable.

This script will set $EDITOR based on $PERL_READLINE_MODE or bash's $SHELLOPTS variable. Any .inputrc editing-mode declaration still takes precedence.

VERSION

Version 1.17

AUTHOR

John Alden with contributions by Simon Flack and Simon Stevenson <cpan _at_ bbc _dot_ co _dot_ uk>

Miguel Gualdron maintainer.

COPYRIGHT

    SQL-Shell:  Interactive shell for DBI Databases
    Copyright (C) 2006  BBC
    Copyright (C) 2019  Miguel Gualdron

    This program is free software; you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation; either version 2 of the License, or
    (at your option) any later version.

    This program is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License
    along with this program; if not, write to the Free Software
    Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

See the file COPYING in this distribution, or https://www.gnu.org/licenses/gpl-2.0.html