list (可简写为 l)
格式:
L 列出缓冲区所有行
L n 列出第n行
L m n 列出从第m行到第n行;
SCOTT@itkaifang> L 1 select 2 deptno, 3 dname, 4 loc 5 from 6 dept 7 where 8* deptno=30 SCOTT@itkaifang> L 5 5* from SCOTT@itkaifang> L 1 6 1 select 2 deptno, 3 dname, 4 loc 5 from 6* dept SCOTT@itkaifang>
append(可简写为 a)添加文本到当前行末尾;
SCOTT@itkaifang> SELECT 2 deptno,dname 3 FROM dept; DEPTNO DNAME ---------- -------------- 10 ACCOUNTING 20 RESEARCH 30 SALES 40 OPERATIONS SCOTT@itkaifang> L 1 SELECT 2 deptno,dname 3* FROM dept SCOTT@itkaifang> L 2 2* deptno,dname SCOTT@itkaifang> A ,loc 2* deptno,dname,loc SCOTT@itkaifang> / DEPTNO DNAME LOC ---------- -------------- ------------- 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES CHICAGO 40 OPERATIONS BOSTON SCOTT@itkaifang>
del 删除当前行(带星号的行)
del n 删除第n行
del m n 删除第m行到第n行;
SCOTT@itkaifang> SELECT 2 empno, 3 ename, 4 sal, 5 deptno 6 FROM 7 emp 8 WHERE 9 deptno=30; EMPNO ENAME SAL DEPTNO ---------- ---------- ---------- ---------- 7499 ALLEN 1600 30 7521 WARD 1250 30 7654 MARTIN 1250 30 7698 BLAKE 2850 30 7844 TURNER 1500 30 7900 JAMES 950 30 6 rows selected. SCOTT@itkaifang> L 1 SELECT 2 empno, 3 ename, 4 sal, 5 deptno 6 FROM 7 emp 8 WHERE 9* deptno=30 SCOTT@itkaifang> DEL 4 SCOTT@itkaifang> L 1 SELECT 2 empno, 3 ename, 4 deptno 5 FROM 6 emp 7 WHERE 8* deptno=30 SCOTT@itkaifang> DEL 7 8 SCOTT@itkaifang> / EMPNO ENAME DEPTNO ---------- ---------- ---------- 7369 SMITH 20 7499 ALLEN 30 7521 WARD 30 7566 JONES 20 7654 MARTIN 30 7698 BLAKE 30 7782 CLARK 10 7788 SCOTT 20 7839 KING 10 7844 TURNER 30 7876 ADAMS 20 7900 JAMES 30 7902 FORD 20 7934 MILLER 10 14 rows selected. SCOTT@itkaifang>
n 指定显示第n行
n text 用文本代替第n行
0 text 在第一行插入文本;
SCOTT@itkaifang> SELECT 2 empno, 3 ename, 4 sal, 5 deptno 6 FROM 7 emp 8 WHERE 9 deptno=20; EMPNO ENAME SAL DEPTNO ---------- ---------- ---------- ---------- 7369 SMITH 800 20 7566 JONES 2975 20 7788 SCOTT 3000 20 7876 ADAMS 1100 20 7902 FORD 3000 20 SCOTT@itkaifang> L 1 SELECT 2 empno, 3 ename, 4 sal, 5 deptno 6 FROM 7 emp 8 WHERE 9* deptno=20 SCOTT@itkaifang> 8 8* WHERE SCOTT@itkaifang> 9 9* deptno=20 SCOTT@itkaifang>
run 执行当前缓冲区中的sql,等于/ ;
SCOTT@itkaifang> L 1 SELECT 2 empno, 3 ename, 4 sal, 5 deptno 6 FROM 7 emp 8 WHERE 9* deptno=20 SCOTT@itkaifang> run 1 SELECT 2 empno, 3 ename, 4 sal, 5 deptno 6 FROM 7 emp 8 WHERE 9* deptno=20 EMPNO ENAME SAL DEPTNO ---------- ---------- ---------- ---------- 7369 SMITH 800 20 7566 JONES 2975 20 7788 SCOTT 3000 20 7876 ADAMS 1100 20 7902 FORD 3000 20 SCOTT@itkaifang>
change (可简写为C)在指定行插入内容;
SCOTT@itkaifang> L 1 SELECT 2 empno, 3 ename, 4 sal, 5 deptno 6 FROM 7* emp SCOTT@itkaifang> c /EMP/EMP WHERE deptno=30; 7* EMP WHERE deptno=30 SCOTT@itkaifang> RUN 1 SELECT 2 empno, 3 ename, 4 sal, 5 deptno 6 FROM 7* EMP WHERE deptno=30 EMPNO ENAME SAL DEPTNO ---------- ---------- ---------- ---------- 7499 ALLEN 1600 30 7521 WARD 1250 30 7654 MARTIN 1250 30 7698 BLAKE 2850 30 7844 TURNER 1500 30 7900 JAMES 950 30 6 rows selected. SCOTT@itkaifang>