SQLPlus.org

SQLPlus

查看表定义

DESCRIBE one_table;

执行SQL语句块

DECLARE
    x   NUMBER := 100;
    BEGIN
        FOR i IN 1..10 LOOP
           IF MOD (i, 2) = 0 THEN    --i is even
             INSERT INTO temp VALUES (i, x, 'i is even');
           ELSE
             INSERT INTO temp VALUES (i, x, 'i is odd');
           END IF;
           x := x + 100;
       END LOOP;
   END;
   .
/

自动保存数据变更

• 打开自动提交

SET AUTOCOMMIT ON

或者

SET AUTICOMMIT IMMEDIATE

• 每执行一定数量DML语句，自动提交

SET AUTOCOMMIT 10

• 关闭自动提交

SET AUTOCOMMIT OFF

修改列名

COLUMN column_name HEADING column_heading

重置列名

COLUMN column_name CLEAR

COLUMN column_name FORMAT model

限制文本字段的长度

COLUMN LAST_NAME FORMAT A4

列值换行，打印行间隔符

• “RECSEP” 决定什么时候打印行间隔符，值”EACH”:每行打印, 值”WRAPPED”:换行发生时，值”OFF”：不要打印
• “RECSEPCHAR”:设置行间隔符

COLUMN JOB_TITLE FORMAT A20 WORD_WRAPPED
SET RECSEP WRAPPED
SET RECSEPCHAR "-"

LAST_NAME                 JOB_TITLE            CITY
------------------------- -------------------- --------
King                      President            Seattle
Kochhar                   Administration Vice  Seattle
                          President
-------------------------------------------------------
De Haan                   Administration Vice  Seattle
                          President
-------------------------------------------------------
Russell                   Sales Manager        Oxford
Partners                  Sales Manager        Oxford
Hartstein                 Marketing Manager    Toronto

6 rows selected.