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