在选择之前,下面的内容与换行符之间是否存在区别
INSERT ALL
INTO LOOKUPTABLE_TYPE VALUES ('LT_EMERGENCY_NUMber','STREAM',1,1)
INTO LOOKUPTABLE_TYPE VALUES ('LT_EMERGENCY_NUMber','BNUMber',2,'Description',3,9,0)
SELECT * FROM dual;
并且在选择前没有新行
INSERT ALL
INTO LOOKUPTABLE_TYPE VALUES ('LT_EMERGENCY_NUMber',0)
SELECT * FROM dual;
我注意到第一个没有在表中插入任何内容,并且在日志中显示为
D
-
X
第二个没有换行符的块在日志中显示为 已创建3行。
++日志
SQL> desc LOOKUPTABLE_TYPE;
Name Null? Type
----------------------------------------- -------- ----------------------------
LOOKUPTABLE_NAME NOT NULL VARCHAR2(32)
COLUMN_NAME NOT NULL VARCHAR2(32)
COLUMN_ORDER NOT NULL NUMber(2)
COLUMN_TYPE NOT NULL NUMber(1)
COLUMN_MODE NOT NULL NUMber(1)
SQL> INSERT ALL
INTO LOOKUPTABLE_TYPE VALUES ('LT_EMERGENCY_NUMber',0)
SELECT * FROM dual; 2 3 4 5 SQL>
D
-
X
SQL> commit
2 ;
Commit complete.
SQL> select * from LOOKUPTABLE_TYPE where LOOKUPTABLE_NAME='LT_EMERGENCY_NUMber';
no rows selected
SQL>
SQL>
SQL>
SQL> INSERT ALL
INTO LOOKUPTABLE_TYPE VALUES ('LT_EMERGENCY_NUMber',0)
SELECT * FROM dual; 2 3 4 5
3 rows created.
SQL> select * from LOOKUPTABLE_TYPE where LOOKUPTABLE_NAME='LT_EMERGENCY_NUMber';
LOOKUPTABLE_NAME COLUMN_NAME COLUMN_ORDER
-------------------------------- -------------------------------- ------------
COLUMN_TYPE COLUMN_MODE
----------- -----------
LT_EMERGENCY_NUMber BNUMber 2
0 1
LT_EMERGENCY_NUMber Description 3
9 0
LT_EMERGENCY_NUMber STREAM 1
0 1