SQL*Plus 学习笔记——常用编辑命令

SQL*PLUS语句执行完成后会保存在SQL缓存区的内存区域中,只能保存一条最近执行的SQL语句,可以对其进行修改再执行

 

 

A[PPEND] PARAM                                                             将PARAM添加到当前行的结尾

 

C[HANGE] /PARAM1/PARAM2                                           将当前行中的PARAM1替换成PARAM2

 

C[HANGE] /PARAM                                                           从当前行删除PARAM

 

CL[EAR] BUFF[ER]                                                            删除缓冲区中的所有行

 

DEL n                                                                               删除第n行

 

DEL                                                                                  删除当前行

 

DEL n LAST                                                                      删除第n行到最后一行

 

I[NPUT] PARAM                                                                当前行后添加新行 内容PARAM

 

L[IST]                                                                              显示所有行

 

L[IST] n 或 n                                                                   显示第n行 并设置其为当前行

 

L[IST] m n                                                                       显示第m行到第n行

 

L[IST] *                                                                           显示当前行

 

R[UN]                                                                              显示缓存区中的内容和运行结果,并使sql缓存区中的最后一行成为当前行

 

/                                                                                      只显示缓存内容的运行结果