sqlsh -d DBI:Oracle:DEVDB -u scott -p tiger
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:
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).
-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
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.
John Alden with contributions by Simon Flack and Simon Stevenson <cpan _at_ bbc _dot_ co _dot_ uk>
Miguel Gualdron maintainer.
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