常用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>