sqlplus中,
"!"可用于不退出而直接执行系统命令行命令
"host"用途同"!"
例:
SQL> !ls
admin oradata oraInventory product
SQL> ls
SP2-0042: unknown command "ls" - rest of line ignored.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
[oracle@devdb168 ~]$ ls
admin oradata oraInventory product
只使用!时,会切换到系统命令行,退出后自动返回sqlplus(win下无法使用):
sql>!
$hostname
$exit
sql>
使用#,将在当前命令不取消的同时运行一条新的的命令,运行完后自动退回到当前命令:
SQL>> select deptno, empno, ename
2 from emp
3 where
6 #desc emp
Name Null? Type
----------------------------------------- -------- --------------
EMPNO NOT NULL NUMBER(4)
ENAME VARCHAR2(10)
JOB VARCHAR2(9)
MGR NUMBER(4)
HIREDATE DATE
SAL NUMBER(7,2)
COMM NUMBER(7,2)
DEPTNO NUMBER(2)
6 sal > 4000;