oracle sql*plus编辑器的使用

最新推荐文章于 2024-09-07 10:06:52 发布

sky@sea

最新推荐文章于 2024-09-07 10:06:52 发布

阅读量745

点赞数

分类专栏： oracle 文章标签： oracle 编辑器 sqlpus

本文链接：https://blog.csdn.net/u013986802/article/details/89532931

版权

oracle 专栏收录该内容

24 篇文章 1 订阅

订阅专栏

描述：

当使用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>