oracle使用什么编辑,oracle sql*plus编辑器的使用

描述：

当使用Oracle的sql*plus时，为了更加方便的书写代码，对前输入的代码重新编辑。因此编辑器可以提高效率。

操作如下：

[root@oaec ~]# su - oracle

[oracle@oaec ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Fri Jan 5 12:03:17 2018

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> conn scott/tiger

Connected.

SQL> define _editor=vi

SQL> ed --当没有执行任何语句时，显示无内容可存

SP2-0107: Nothing to save.

SQL> select * from v_emp_dept where rownum<300; --执行查询语句

EMPNO ENAME JOB MGR HIREDATE DNAME LOC

---------- ---------- --------- ---------- --------- -------------- -------------

7369 SMITH CLERK 7902 17-DEC-80 RESEARCH DALLAS

7499 ALLEN SALESMAN 7698 20-FEB-81 SALES CHICAGO

7521 WARD SALESMAN 7698 22-FEB-81 SALES CHICAGO

7566 JONES MANAGER 7839 02-APR-81 RESEARCH DALLAS

7654 MARTIN SALESMAN 7698 28-SEP-81 SALES CHICAGO

7698 BLAKE MANAGER 7839 01-MAY-81 SALES CHICAGO

7782 CLARK MANAGER 7839 09-JUN-81 ACCOUNTING NEW YORK

7788 SCOTT ANALYST 7566 19-APR-87 RESEARCH DALLAS

7839 KING PRESIDENT 17-NOV-81 ACCOUNTING NEW YORK

7844 TURNER SALESMAN 7698 08-SEP-81 SALES CHICAGO

7876 ADAMS CLERK 7788 23-MAY-87 RESEARCH DALLAS

EMPNO ENAME JOB MGR HIREDATE DNAME LOC

---------- ---------- --------- ---------- --------- -------------- -------------

7900 JAMES CLERK 7698 03-DEC-81 SALES CHICAGO

7902 FORD ANALYST 7566 03-DEC-81 RESEARCH DALLAS

7934 MILLER CLERK 7782 23-JAN-82 ACCOUNTING NEW YORK

14 rows selected.

SQL> ed --将查询语句写入afledt.buf

Wrote file afiedt.buf

1* select * from v_emp_dept where rownum<4

SQL> /

EMPNO ENAME JOB MGR HIREDATE DNAME LOC

---------- ---------- --------- ---------- --------- -------------- -------------

7369 SMITH CLERK 7902 17-DEC-80 RESEARCH DALLAS

7499 ALLEN SALESMAN 7698 20-FEB-81 SALES CHICAGO

7521 WARD SALESMAN 7698 22-FEB-81 SALES CHICAGO

SQL> ed --此时会进入vi编辑区

select * from v_emp_dept where rownum<4

/

~

~

~

~ vi编辑区

~

~

~

"afiedt.buf" 2L, 42C

注：按字母i进入编辑模式，待编辑好后，将斜杠“/”删除，然后保存退出(保存步骤：ese->:wq->enter)

Wrote file afiedt.buf

1* select * from v_emp_dept where rownum<4;

SQL> /--执行刚编辑的语句

EMPNO ENAME JOB MGR HIREDATE DNAME LOC

---------- ---------- --------- ---------- --------- -------------- -------------

7369 SMITH CLERK 7902 17-DEC-80 RESEARCH DALLAS

7499 ALLEN SALESMAN 7698 20-FEB-81 SALES CHICAGO

7521 WARD SALESMAN 7698 22-FEB-81 SALES CHICAGO

SQL>

标签：CHICAGO,where,sql,plus,emp,SQL,oracle,7698,select

来源： https://blog.csdn.net/u013986802/article/details/89532931