【SQLPlus】常用命令集合

list

ho cls--------------------------------------clear screen

set linesize 500

set pagesize 50

column ename format a20;column empno format 9999;

/

spool "E:\GitHub repositories\Uplearning\Read\Oracle\knowledge\Material\spool_1"select * from emp;--示例SQLspool off

@ "E:\GitHub repositories\Uplearning\Read\Oracle\knowledge\Material\xplan.sql"

edit

desc--desc+空格+表名

set feedback on;

set heading on;

set serveroutput on;

set timing on;

set colsep' ';