1、不带条件的INSERT ALL用法：
SQL> CREATE TABLE TABLE_STORAGE
  2  (
  3  TABLE_NAME VARCHAR2(30),
  4  TABLESPACE_NAME VARCHAR2(30),
  5  PCT_FREE NUMBER,
  6  PCT_USED NUMBER,
  7  INI_TRANS NUMBER,
  8  MAX_TRANS NUMBER,
  9  INITIAL_EXTENT NUMBER,
 10  NEXT_EXTENT NUMBER,
 11  MIN_EXTENTS NUMBER,
 12  MAX_EXTENTS NUMBER,
 13  PCT_INCREASE NUMBER,
 14  FREELISTS NUMBER,
 15  FREELIST_GROUPS NUMBER
 16  );

SQL> CREATE TABLE TABLE_STAT
  2  (
  3  TABLE_NAME VARCHAR2(30),
  4  NUM_ROWS NUMBER,
  5  BLOCKS NUMBER,
  6  EMPTY_BLOCKS NUMBER,
  7  AVG_SPACE NUMBER,
  8  CHAIN_CNT NUMBER,
  9  AVG_ROW_LEN NUMBER
 10  );

SQL> INSERT ALL
  2  INTO TABLE_STORAGE VALUES (TABLE_NAME, TABLESPACE_NAME, PCT_FREE, PCT_USED,
  3  INI_TRANS, MAX_TRANS, INITIAL_EXTENT, NEXT_EXTENT, MIN_EXTENTS, MAX_EXTENTS,PCT_INCREASE, FREELISTS, FREELIST_GROUPS)
  4  INTO TABLE_STAT VALUES (TABLE_NAME, NUM_ROWS, BLOCKS, EMPTY_BLOCKS, AVG_SPACE,CHAIN_CNT, AVG_ROW_LEN)
  5  SELECT * FROM USER_TABLES;

2、带条件的INSERT ALL用法：
SQL> CREATE TABLE TABLE_ALL (TABLE_NAME VARCHAR2(30));
SQL> CREATE TABLE INDEX_ALL (INDEX_NAME VARCHAR2(30));
SQL> CREATE TABLE OBJECT_OTHER (OBJECT_NAME VARCHAR2(30), OBJECT_TYPE VARCHAR2(30));
SQL> INSERT ALL 
  2  WHEN (object_type = 'TABLE') THEN INTO table_all VALUES  (object_name) 
  3  WHEN (object_type = 'INDEX') THEN INTO index_all VALUES  (object_name) 
  4  ELSE INTO object_other (OBJECT_NAME, OBJECT_TYPE)
  5  SELECT object_name, object_type FROM user_objects;

01.Oracle实现字段自动增长 
02.序列：
03.CREATE SEQUENCE myseq INCREMENT BY 1 START WITH 1 
04.MAXvalue 1.0E28 MINvalue 1 NOCYCLE 
05.CACHE 20 NOORDER;
06.07.触发器：
08.CREATE OR REPLACE TRIGGER mytrigger BEFORE
09.INSERT ON mytable FOR EACH ROW begin
10.Select myseq.Nextval into :New.ID From Dual; 
11.end; 

--mysql远程连接授权

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;