sqlsh - SQL shell
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:
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).
-d <DSN> -u <username> -p <password> -i - read list of commands from STDIN -q - quiet (no banner) -H - help
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.
$EDITOR
This script will set $EDITOR based on $PERL_READLINE_MODE or bash's $SHELLOPTS variable. Any .inputrc editing-mode declaration still takes precedence.
editing-mode
$Revision: 1.50 $ on $Date: 2006/12/05 11:38:47 $ by $Author: andreww $
John Alden with contributions by Simon Flack <cpan _at_ bbc _dot_ co _dot_ uk>
(c) BBC 2006. This program is free software; you can redistribute it and/or modify it under the GNU GPL.
See the file COPYING in this distribution, or http://www.gnu.org/licenses/gpl.txt
To install SQL::Shell, copy and paste the appropriate command in to your terminal.
cpanm
cpanm SQL::Shell
CPAN shell
perl -MCPAN -e shell install SQL::Shell
For more information on module installation, please visit the detailed CPAN module installation guide.