在PL/SQL执行程序代码:
CREATE GLOBAL TEMPORARY TABLE temp
(
a int,
b char(32),
c decimal(20,4),
d decimal(20,4)
)
ON COMMIT delete ROWSinsert into temp(a,b,c)
select 2, 2,2 from dualinsert into temp(a,b,d)
select 2, 2,2 from dual同时执行INSERT代码
错误提示SQL命令为正确执行
求解!!!!!
CREATE GLOBAL TEMPORARY TABLE temp
(
a int,
b char(32),
c decimal(20,4),
d decimal(20,4)
)
ON COMMIT delete ROWSinsert into temp(a,b,c)
select 2, 2,2 from dualinsert into temp(a,b,d)
select 2, 2,2 from dual同时执行INSERT代码
错误提示SQL命令为正确执行
求解!!!!!
insert into temp(a,b,c)
select 2, 2,2 from dual;insert into temp(a,b,d)
select 2, 2,2 from dual
CREATE GLOBAL TEMPORARY TABLE temp
(
a int,
b char(32),
c decimal(20,4),
d decimal(20,4)
)
ON COMMIT delete ROWS;insert into temp(a,b,c)
select 2, 2,2 from dual;insert into temp(a,b,d)
select 2, 2,2 from dual;