SET PAUSE [ ON | OFF ].................................................................................................................155
SQL> set pause on............................................................................................................................155
§2.5.7 SPACE(列间空格).................................................................................................155
§2.5.8 Termout (启/停屏幕显示).....................................................................................155
SET TERMOUT { ON | OFF }.........................................................................................................155
§2.5.9 ECHO (启/停命令显示)........................................................................................156
§2.5.10 TRANSACTION (启动事务).............................................................................156
§2.5.11 SHOW ALL(列出所有参数)..............................................................................156
SQL> show all..................................................................................................................................156
SQL>.................................................................................................................................................158
§2.6 格式化输出.......................................................................................................................158
§2.6.1 一般数据的格式化输出.......................................................................................158
COL[UMN] [{ column | expr } [ option_1 ... option_n ] ]...............................................................158
FOLD_A[FTER]...............................................................................................................................159
FOLD_B[EFORE]............................................................................................................................159
FOR[MAT] format............................................................................................................................159
SQL> col ename heading 姓名 format a10......................................................................................159
SQL...................................................................................................................................................159
COLUMN SALARY FOR $9,999,999.99........................................................................................159
§2.6.2 日期的格式化输出...............................................................................................160
SQL> select sysdate from dual;........................................................................................................160
SYSDATE.........................................................................................................................................160
SQL> connect scott/tiger..................................................................................................................160
§2.7 加标题...............................................................................................................................161
§2.8 建立简单报告...................................................................................................................161
SQL>SPOOL OFF............................................................................................................................163
§2.9 输入变量...........................................................................................................................163
Select sid, serial#,username, command from v$session...................................................................163
SQL> Select sid, serial#,username, command from v$session........................................................163
SQL> Select sid, serial#,username, command from v$session;.......................................................164
SQL> set define ?..............................................................................................................................164
SQL> show define............................................................................................................................165
第三章 表及索引的定义操作.........................................................................................................166
§3.1 建立表结构.......................................................................................................................166
§3.1.1 建立表结构命令...................................................................................................166
CREATE TABLE [USER.] table_name...........................................................................................166
§3.1.2 建立表结构例子...................................................................................................168
CREATE TABLE CHECKUP_HISTORY.......................................................................................168
CREATE TABLE SEAPARK.CHECKUP_HISTORY....................................................................169
CHECKUP_NO NUMBER(10) NOT NULL,.................................................................................169
PCTFREE 20.....................................................................................................................................169
PCTUSED 60....................................................................................................................................169
§3.1.3 建立临时表结构...................................................................................................169
SQL> create global temporary table myemp as select * from emp;................................................169