使用help index获取sqlplus命令列表
SQL@itkaifang> 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 XQUERY CONNECT PASSWORD SHOW SQL@itkaifang> help get GET --- Loads a SQL statement or PL/SQL block from a script into the SQL buffer. The buffer has no command history list and does not record SQL*Plus commands. GET [FILE] file_name[.ext] [LIST | NOLIST]
命令实测
“@”(运行指定的命令文件)
“@@”(运行嵌套的命令文件,在命令文件相同路径下寻找)
(在实际测试中在命令文件中,使用@或@@均会在命令文件同路径下寻找嵌套的命令文件。官方文档未描述该现象)
SYS@test> !vi test.sql SYS@test> @test.sql USERNAME ------------------------------ SYS SYSTEM SYS@test> @test USERNAME ------------------------------ SYS SYSTEM SYS@test> l 1* select username from dba_users where rownum<=2 SYS@test> !cat test.sql select username from dba_users where rownum<=2; @@test1.sql SYS@test> @test USERNAME ------------------------------ SYS SYSTEM USERNAME ------------------------------ SYS SYSTEM OUTLN SYS@test> !cat test1.sql select username from dba_users where rownum<=3; SYS@test> !cat test.sql select username from dba_users where rownum<=2; @test1.sql SYS@test> !cat test1.sql select username from dba_users where rownum<=3; SYS@test> @test USERNAME ------------------------------ SYS SYSTEM USERNAME ------------------------------ SYS SYSTEM OUTLN
“/ ”或”run”执行上一次SQL语句
SYS@test> select username from dba_users where rownum<=2; USERNAME ------------------------------ SYS SYSTEM SYS@test> run 1* select username from dba_users where rownum<=2 USERNAME ------------------------------ SYS SYSTEM SYS@test> / USERNAME ------------------------------ SYS SYSTEM
”host“或“!”调用系统命令,或临时调用系统命令窗口
SYS@test> ! [oracle@11204 ~]$ exit exit SYS@test> host [oracle@11204 ~]$ exit exit SYS@test> !cat a.sql cat: a.sql: No such file or directory SYS@test> host cat a.sql cat: a.sql: No such file or directory
show查看命令
SCOTT@itkaifang> show user USER is "SCOTT" SCOTT@itkaifang> show linesize linesize 300 SCOTT@itkaifang> show pagesize pagesize 30
startup启动数据库
SYS@itkaifang> startup ORACLE instance started. Total System Global Area 830930944 bytes Fixed Size 2217912 bytes Variable Size 507512904 bytes Database Buffers 318767104 bytes Redo Buffers 2433024 bytes Database mounted. Database opened. SYS@itkaifang>
shutdown immediate关闭数据库
SYS@itkaifang> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SYS@itkaifang>
exit退出数据库
SYS@itkaifang> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oracle@itkaifang ~]$
sqlplus进入SQL*Plus工具(格式:sqlplus 用户名/密码 或 / as sysdba)
[oracle@itkaifang ~]$ sqlplus scott/tiger SQL*Plus: Release 11.2.0.1.0 Production on Tue Mar 7 13:48:37 2017 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Session altered. SCOTT@itkaifang>
ed (edit的简写)
ed -->编辑上一条SQL语句(需指定默认编辑器,可参考SQL*Plus环境设置);
ed (指定脚本、文件名)-->编辑指定文件,不存在则新建,不指定路径默认保存在oracle家目录下。