官方文档

http://docs.oracle.com/cd/B19306_01/server.102/b14357/toc.htm

一、

1.sqlplus帮助安装

执行oracle_home\sqlplus\admin\help下的脚本，具体参考文档

2.sqlplus连接选项

a.查看sqlplus帮助

sqlplus -h

b.查看sqlplus版本

sqlplus -v

3.显示所有sqlplus命令

SQL> help index

Enter Help [topic] for help.

@             COPY         PAUSE                    SHUTDOWN
@@            DEFINE       PRINT                    SPOOL
/             DEL          PROMPT                   SQLPLUS
ACCEPT        DESCRIBE     QUIT                     START
APPEND        DISCONNECT   RECOVER                  STARTUP
ARCHIVE LOG   EDIT         REMARK                   STORE
ATTRIBUTE     EXECUTE      REPFOOTER                TIMING
BREAK         EXIT         REPHEADER                TTITLE
BTITLE        GET          RESERVED WORDS (SQL)     UNDEFINE
CHANGE        HELP         RESERVED WORDS (PL/SQL) VARIABLE
CLEAR         HOST         RUN                      WHENEVER OSERROR
COLUMN        INPUT        SAVE                     WHENEVER SQLERROR
COMPUTE       LIST         SET
CONNECT       PASSWORD     SHOW

3.查看某个命令的帮助

SQL> help spool

SPOOL
-----

Stores query results in a file, or optionally sends the file to a printer.
In iSQL*Plus, use the Preferences screen to direct output to a file.

SPO[OL] [file_name[.ext] [CRE[ATE] | REP[LACE] | APP[END]] | OFF | OUT]

Not available in iSQL*Plus

二、sqlplus命令

1.list

列出存储在sql缓冲区中执行过的sql命令和pl/sql块语句，也可以使用";"来显示.

SQL> select count(*) from emp;

COUNT(*)
----------
14

SQL> ;
1* select count(*) from emp
SQL> list
1* select count(*) from emp

2.run和/

run:显示和执行最近执行过的sql命令

SQL> run
1* select count(*) from emp

COUNT(*)
----------
14

/: 不显sql命令

SQL> /

COUNT(*)
----------
14

ITPub博客

sqlplus(一)

最新文章