常用SQLPLUS快捷修改语句

1.修改

SQL> 3

  3*   WHERE t.table_name ='SCOTT'

SQL> c/SCOTT/EMP

  3*   WHERE t.table_name ='EMP'

SQL> 

2.添加

SQL> select *

  2   from emp;

from emp

      *

ERROR at line 2:

ORA-00942: table or view does not exist

SQL> a   where empname='SCOTT'; --注意是空2个空格

  2* from emp where empname='SCOTT'

SQL>